|
Syntax
|
...,
ByRef parameter,...
|
|
Description
|
Used within the
Sub...End Sub,
Function...End Function, or Declare statement to specify that a given parameter can be modified by the called routine.
|
|
Comments
|
Passing a parameter by reference means that the caller can modify that variable's value.
Unlike the ByVal keyword, the ByRef keyword cannot be used when passing a parameter. The absence of the ByVal keyword is sufficient to force a parameter to be passed by reference:
MySub ByVal I '<-- Pass i by value.
MySub ByRef i '<-- Illegal (will not compile).
MySub i '<-- Pass i by reference.
|
|
Example
|
Sub Test(ByRef a As Variant)
a = 14
End Sub
Sub Main()
b = 12
Test b
MsgBox "The ByRef value is: " & b ' <-- Displays 14.
End Sub
|
|
See Also
|
() (keyword), ByVal (keyword).
|