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
