All of the expressions in a Switch or IIF statement are evaluated whether or not
they are true. An If/Then or Select case statement stops evaluation with the
first condition that is True. Draw your own conclusion.

I tend to favor the Select Case statement for more than 3 conditions.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Brent"
wrote in message
Does anyone know the difference in runtime and memory usage for
IF..Then..Else and a Switch statement in VBA, when the two are equivalent
expressions? Thank you.

Brent