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