ByVal or ByRef
Passing variables by reference is the default and this means that you pass a pointer to the variable and therefore the variable's value can be changed inside the procedure or function.
Passing an argument by reference is the default.
Sub Proc_Name(Name As String)
Sub Proc_Name(ByRef Name As String)
If you pass a variable defined as a user defined data type to a procedure, it must be passed by reference.
Attempting to pass it by value will cause an error.
Passing arguments by value passes a copy of the variable and changing the value will only affect the local copy.
This should be used when you do not want the procedure to modify the actual variable but just to use the value.
Sub Proc_Name(ByVal Name As String)
Passing in Value Data Types
Value data types are also referred to as simple data types.
Passing in Reference Data Types
Reference data types are also referred to as object types.
In VBA all objects are passed by reference although there is a difference.
ByRef - the address of the object is passed.
ByVal - a copy of the address to the object is passed.
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext