Programming Reference Manual

IfNull

 
Syntax
 
expr IfNull(expr [, NullReplacement])
 
Description
Returns a replacement value when the tested expression is empty or has a null value.
 
Parameter
Description
expr
Expression to be evaluated
NullReplacement
Optional. Replacement value in case expr is null or empty. Default value is 0 (zero).
See Also
IsEmpty, IsNull.
Example
 
Sub Main
    Dim X As Variant
    Debug.Print ifnull(X, "not assigned")
End Sub