IsNull Function

Syntax
IsNull(expr)
Group
Variable Info
Description
Return the True if expr is Null.
Parameters Description
expr A variant expression to test for Null.
See Also
IsNull, TypeName, VarType

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