Select Case Statement

[VBUser77]

Is it possible to check the value of multiple variables at the same time through select case statement. In other words can i do this:

Select Var1, Var2

case 2, 3
Code comes here

End Select

If Var1 is 2 and Var2 is 3 then execute the code.

Thanks a lot in advance for your help.

Jay

 

[RoyVidar]

The select case statement only evaluates one criterion.

[tt]select case var1
case 2, 3, 5 to 10
...[/tt]

but, you can also do the following:

[tt]select case true
case Var1 = 2 and Var2 = 3
...[/tt]

Roy-Vidar

 

[VBUser77]

Thanks a lot