Solved: Test Multiple Variable for Same Result

[fb7894]

What's the best way to test multiple variable to see if they have the same value?

Example:
[vba]
Dim Var1 as Long
Dim Var2 as Long
Dim Var3 as Long
Dim Var4 as Long

If all 4 Variables are the same Then
Goto Here
Else
Goto There
End if
[/vba]

What's the best way to write the line in Red? Thanks.

[CreganTur]

There are many ways to test this. One way is like this:
[VBA]Sub Test()
Dim a As Integer, x As Integer, y As Integer, b As Integer
a = 1
b = 1
x = 1
y = 1
If (a = b And b = x And x = y) Then
MsgBox "Match!"
End If
End Sub[/VBA]