IsEmpty

Returns a Boolean value indicating whether a variable has been initialized.

Syntax
      IsEmpty(expression)

Key
   expression    Any expression. However, because IsEmpty() is used to determine if
                 variables are initialized, this is most often a variable name.

IsEmpty returns True if the variable is uninitialized, or is explicitly set to Empty; otherwise, it returns False. False is always returned if expression contains more than one variable.

Examples

Test whether a variable has been initialized:

Dim MyVar, MyCheck

MyCheck = IsEmpty(MyVar) ' Returns True.

MyVar = Null
MyCheck = IsEmpty(MyVar)
' Returns False.

MyVar = Empty
MyCheck = IsEmpty(MyVar)
' Returns True.

“I have no money, no resources, no hopes. I am the happiest man alive” ~ Henry Miller

Related:

Syntax - IsBlank function to detect Empty or NULL or Zero.


© Copyright SS64.com 1999-2013
Some rights reserved