The process of VBA learning notes

Show VBA procedure has value and address, pass value is sub xxx (ByVal variable), pass the address to sub XXX (ByRef variable)

Difference: A variable that is referenced by a value does not change its initial value after the child procedure that called it is run .

My understanding: The variable is stored in the memory address, the pass value passes the variable instead of the address of the variable, so the initial value of the variable is not changed, the address of the variable is passed, so the variable is changed.

The process of VBA learning notes