Syntax

TypeOf objectvariable Is objecttype

Description

Returns TRUE if objectvariable is the specified typel; otherwise FALSE.

Comments

This function is used within the If...Then statement to determine if a variable is of a particular type. This function is particularily useful for determining the type of OLE automation objects.

Example

Sub Main()

  Dim a As Object

  Set a = CreateObject("Excel.Application")

  If TypeOf a Is "Application" Then

    MsgBox "We have an Application object."

  End If

End Sub

See Also

TypeName (function)

T