Return TRUE if the expression is a variable has been initialised, otherwise return FALSE.
Syntax IsEmpty(expression) Key expression A variable.
The IsEmpty() function can be used in VBA.
Examples
Dim intDemo as Integer, result
result = IsEmpty(intDemo)
Returns True
“An optimist will tell you the glass is half-full; the pessimist, half-empty; and the engineer will tell you the glass is twice the size it needs to be”
Related:
IsNull - Test for a NULL expression.
Nz - Test for a NULL expression or Zero Length String.