Developer.com content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.
Have you come across the IIf function? This is what help says:
Syntax
IIf(expr, truepart, falsepart)
The IIf function syntax has these named arguments:
| Part | Description |
| expr | Required. Expression you want to evaluate. |
| truepart | Required. Value or expression returned if expr is True. |
| falsepart | Required. Value or expression returned if expr is False. |
Then you would use it as follows:
MsgBox "Hello " & IIf(strName="John", _ "John", "some one else") & ". How are you?", vbOK
This is a very mundane example, but you get the idea: it can save a lot of code if you
just want to evaluate something little. Did you know that it is part of the VBA DLL? This
means that if you are only writing a small prgram that does not use anything else from the
VBA library then you could cut out this DLL. This is how:
Public Function IIf2(arg As Boolean, _
ret1 As Variant, ret2 As Variant) As Variant
If arg Then
IIf2 = ret1
Else
IIf2 = ret2
End If
End Function
