ISNULL

ISNULL(expression)

Returns the value True or False depending if the expression contains no data (Boolean).

expression

The expression to test.

REMARKS

* The Null Value can only be used in conjunction with the Variant data type.
* If "expression" is Null, then True is returned.
* If "expression" contains more than one variable and any of these variables are Null, then True is returned.
* You can use the ISARRAY function to return True or False depending if the value is an array.
* You can use the ISDATE function to return True or False depending if the value is a date.
* You can use the ISEMPTY function to return True or False depending if the variable has been initialised.
* You can use the ISERROR function to return True or False depending if the value is an error.
* You can use the ISMISSING function to return True or False depending if an optional argument has been passed in.
* You can use the ISNUMERIC function to return True or False depending if the value is a number.
* You can use the ISOBJECT function to return True or False depending if the variable represents an object.
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print IsNull(Null)             '= True  
Debug.Print IsNull("")               '= False  
Debug.Print IsNull(100)              '= False  
Debug.Print IsNull("12 July 2024")   '= False