This example is the way that I’ve been using most for I’d like to maintain the value of x.
Is this function ByVal ?
Sub Is_this_ByRef_or_ByVal
Dim x%
x = 10
MsgBox "Is this ByRef or ByVal ?" & Chr(13) & Chr(13) & _
"Sub Is_this_ByRef_or_ByVal" & Chr(13) & _
" Dim x%" & Chr(13) & _
" x = 10" & Chr(13) & _
" MsgBox ''Triple(x) = '' & Triple(x) & Chr(13) & ''x = '' & x" & Chr(13) & _
"End Sub" & Chr(13) & Chr(13) & _
"Function Triple%(x%)" & Chr(13) & _
" Triple = x * 3" & Chr(13) & _
"End Function" & Chr(13) & Chr(13) & _
"Result :" & Chr(13) & _
" Triple(x) = " & Triple(x) & Chr(13) & _
" x = " & x
End Sub
Function Triple%(x%)
Triple = x * 3
End Function