If Or

[atesh]

What's the best way to write the following:

If a = b Or a = c Or a = d Or a = e Then
...

 

[Volte]

Nothing wrong with that, except you should use the logic OrElse operator.

If a = b OrElse a = c OrElse a = d OrElse a = e Then

 

[Diablicolic]

Why OrElse other than Or?

 

[Volte]

Or is for boolean math, OrElse is for logical comparison. It's basically Or in VB is | in C++, and OrElse in VB is || in C++. I believe it will evaluate each expression individually and if it is false, it'll evaluate the next one, and if it's true it'll go right into the If block.

 

[Diablicolic]

..hmm...so orelse is faster than or?

 

[Robby]

As well you can use the new AndAlso.

It behaves somewhat like OrElse, if the first condition is false it stops evaluating.

 

[Robby]

Yes they are both faster because they only evaluate until the condition is not met.