The VBA IsObject Function

Related Functions:

VBA IsArray
VBA IsDate
VBA IsEmpty
VBA IsError
VBA IsMissing
VBA IsNull
VBA IsNumeric

Description

The VBA IsObject function returns a Boolean, indicating whether a supplied variable represents an Object variable type.

The syntax of the function is:

IsObject( Expression )

Where the supplied Expression is the variable name that you want to test.

VBA IsObject Function Examples

The following example uses the VBA IsNumeric function to test four variables.

' Test if variables var1 and var2 represent Object variable types.

								Dim var1 As Object

								Dim var2, var3, var4

								Dim isObj1 As Boolean

								Dim isObj2 As Boolean

								Dim isObj3 As Boolean

								Dim isObj4 As Boolean

								isObj1 = IsObject( var1 )

								' The variable isObj1 is now equal to True.

								isObj2 = IsObject( var2 )

								' The variable isObj2 is now equal to False.

								Set var3 = Range( "A1" )

								isObj3 = IsObject( var3 )

								' The variable isObj3 is now equal to True.

Set var4 = Range( "A1" )
Set var4 = Nothing
isObj4 = IsObject( var4 )
' The variable isObj4 is now equal to True.

The above examples show that the isObject function returns:

True for variables that are defined as Object types, even if they are not initialized;
False for Variants that are not initialized;
True for Variants that have objects assigned to them;
True for Variants that have previously had objects assigned to them (even if they are now set to Nothing).

Return to the VBA Functions Page
Return to the Excel VBA Tutorial Page