In the following code, I get a compile time error because i
is treated as a variant. The error is: "ByRef Argument type mismatch.".
But if I pass the parameters ByVal
, there is no error why?
Private Sub Command2_Click()
Dim i, j As Integer
i = 5
j = 7
Call Swap(i, j)
End Sub
Public Sub Swap(ByRef X As Integer, ByRef Y As Integer)
Dim tmp As Integer
tmp = X
X = Y
Y = tmp
End Sub