More Efficient IF

  • Thread starter Thread starter David
  • Start date Start date
D

David

I posted this 2 hrs ago but it seems to have disappeared, apologies if
it reappears and this is a double post!

I have an IF statement thus:

--

IF Variable = 1 or Variable = 2 or Variable = 7 or Variable = 12 then

--

Is there a more efficient way to do this?

In PICK BASIC for example you have the MATCHES function:

--

If Variable MATCHES (1,2,7,12) Then

--

Is there anything like that in VBA? Are there any other tips to
improve efficiency/speed in VBA such as putting brackets around
conditionals etc?

Thanks!
 
Hi David

You could use the select case statement


Select Case variable

Case 1, 2, 7, 12

MsgBox "Variable is either 1,2,7,12"

End Select

hope this helps

S
 
Back
Top