VBA IsNull Function: The IsNull function in VBA returns a Boolean, indicating whether a supplied expression is Null.

Syntax

Parameter

Expression (required)– This parameter represents the name of the argument that you want to check.

Return

This function returns a Boolean value True if the specified expression is null else it returns False if the argument has been supplied.

Example 1

Output

The isNull function returns FALSE
Excel VBA IsNull Function

Example 2

Output

The isNull function returns TRUE
Excel VBA IsNull Function

Example 3

Output

The isNull function returns FALSE
Excel VBA IsNull Function

Pin It on Pinterest

Share This