IsNull Function

Tests if a Variant contains the special Null value, indicating that the variable does not contain data.

Syntax:


IsNull (Var)

Return value:

Boolean

Parameters:

Var: Any variable that you want to test. This function returns True if the Variant contains the Null value, or False if the Variant does not contain the Null value.

Null - This value is used for a variant data sub type without valid contents.

Error codes:

5 Invalid procedure call

Example:


Sub ExampleIsNull
Dim vVar As Variant
    MsgBox IsNull(vVar)
End Sub