IsNull Function
Syntax:
IsNull(expr)
Group:
Variable Info
Description:
Return the True if expr
is Null.
Parameter
Description
expr A
variant expression to test for Null.
See
Also: TypeName, VarType.
Example:
Sub Main
Dim X As Variant
Debug.Print IsEmpty(X)
'True
Debug.Print IsNull(X) 'False
X = 1
Debug.Print IsNull(X) 'False
X = "1"
Debug.Print IsNull(X) 'False
X = Null
Debug.Print IsNull(X) 'True
X = X*2
Debug.Print IsNull(X) 'True
End Sub