<div>
Good to read<br />
<br />
Passing Arguments by Value and by Reference (Visual Basic)<br />
<a href="https://msdn.microsoft.com/en-us/library/ddck1z30.aspx" rel="ugc nofollow">https://msdn.microsoft.com/en-us/library/ddck1z30.aspx</a>
</div>


Good to read

Passing Arguments by Value and by Reference (Visual Basic)
https://msdn.microsoft.com/en-us/library/ddck1z30.aspx [https://msdn.microsoft.com/en-us/library/ddck1z30.aspx]

<div>
also for references<br />
<br />
How to: Protect a Procedure Argument Against Value Changes (Visual Basic)<br />
<a href="https://msdn.microsoft.com/en-us/library/xw55ed62.aspx" rel="ugc nofollow">https://msdn.microsoft.com/en-us/library/xw55ed62.aspx</a><br />
<br />
How to: Change the Value of a Procedure Argument (Visual Basic)<br />
<a href="https://msdn.microsoft.com/en-us/library/6zxyfyzz.aspx" rel="ugc nofollow">https://msdn.microsoft.com/en-us/library/6zxyfyzz.aspx</a><br />
<br />
How to: Force an Argument to Be Passed by Value (Visual Basic)<br />
<a href="https://msdn.microsoft.com/en-us/library/chy4288y.aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/chy4288y.aspx</a><br />
<br />
look for the links on the left hand side.
</div>


also for references

How to: Protect a Procedure Argument Against Value Changes (Visual Basic)
https://msdn.microsoft.com/en-us/library/xw55ed62.aspx [https://msdn.microsoft.com/en-us/library/xw55ed62.aspx]

How to: Change the Value of a Procedure Argument (Visual Basic)
https://msdn.microsoft.com/en-us/library/6zxyfyzz.aspx [https://msdn.microsoft.com/en-us/library/6zxyfyzz.aspx]

How to: Force an Argument to Be Passed by Value (Visual Basic)
https://msdn.microsoft.com/en-us/library/chy4288y.aspx [https://msdn.microsoft.com/en-us/library/chy4288y.aspx]

look for the links on the left hand side.

<div>
thanks very much fanpages. &nbsp;very well explained.
</div>


thanks very much fanpages.  very well explained.

<div>
thank you Ryan Chong as well.
</div>


<div>
you're welcome Flora, you can get further details from the links I had provided. cheers...
</div>


you're welcome Flora, you can get further details from the links I had provided. cheers...

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
i really need to learn what is the difference between ByRef and ByVal , and how they are used and when should we use ByRef and when should we use ByVal.<br />
<br />
i would appreciate if someone can explain with a simple examples.<br />
<br />
thanks.
</div>
</div>


Hello,

i really need to learn what is the difference between ByRef and ByVal , and how they are used and when should we use ByRef and when should we use ByVal.

i would appreciate if someone can explain with a simple examples.

thanks.

By Ref and ByVal  explained in plain examples

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.