Learning differences between ByVal and ByRef

Hello mc84excel,

ByRef and Byval have to do with "pointers". A pointer is an address to a memory location. Variables will place a pointer on the stack when called.

ByRef (BY Reference) indicates that the variable has been dimensioned in the procedure and assigned a value or to and object. The main purpose of ByRef is to modify and existing variable or object directly from a remote call.

ByVal (By Value) indicates that variable has not been created and exists as a constant value within the calling expression. A "copy" is made and stored in a temporary memory location that the calling procedure can access.