Quote Originally Posted by Paul_Hossler View Post
I use (like ) IIf for things like

FinalCost = IIf (IsTaxable, BasicCost * TaxRate, BasicCost)
I like IIf as well, I really detest putting a simple test like that in a If ... Else ... Endif, but as Rory says, you have to be careful, there is no short-circuiting in VBA.

But I like b = 6 = 5 even more, I use that structure all of the time.

As an aside, on something Rory said, I never, or more probably rarely use <> I use Not ... =, for example

If Not myvariable = somevalue Then

for some reason I decided some time ago that the condition is equality, so only test for equal and use Not if you want to know when it isn't.