Name
IsObject Function
Syntax
IsObject(varname)-
varname Use: Required
Data Subtype: Any
Name of the variable to be evaluated.
Return Value
Boolean (True or False).
Description
Indicates whether a variable contains a reference to an object—in other words, if it’s an object variable.
Rules at a Glance
If the variable passed to IsObject references or
has referenced an object, even if its value is
Nothing, True is returned;
otherwise, IsObject returns
False.
Programming Tips & Gotchas
IsObjectdoesn’t validate the reference being held by an object variable; it simply determines if the variable is an object. To ensure that an object reference is valid, you can use the syntaxIsNothing, as shown in this code snippet:If objVar is Nothing Then ... End if
IsObjectis simply a “convenience” function that is roughly equivalent to the following user-defined function:Public Function IsObject(varObj) If VarType(varObj) = vbObject Then IsObject = True Else IsObject = False End If End Function
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access