Selections

[Juggler]

I am looking for a better way to use an IF statement then using something like:
"if intAdmin = 1 or intAdmin = 2 or intAdmin = 3......... then"
How can I make the if statement look for 8 different numbers without using all those "OR"s?
Thanks in advance.

[TonyES]

In VBA, you can use Select Case:

Select Case intAdmin
Case 1 To 5, 12, 37
' some code here
...
Case 6, 9 To 11
' some other code here
...
Case Else ' all other values
' more code
...
End Select

[Juggler]

Great Tony.