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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More Efficient IF 7
Efficiency of Dynamic ranges 4
More Efficient If Statement 5
VBA function to replace nested IFs 8
More Efficient If function 3
Improving Nested Formula Calculation Efficiency 2
find mid value of string data in data with integers 2
Using a variable in an If statement 7

Back
Top