SmartTagRecognizers Collection

Microsoft Excel Visual Basic

SmartTagRecognizers Collection

Application SmartTagRecognizers
SmartTagRecognizer

A collection of SmartTagRecognizer objects that represent recognition engines which label data with types of information as you work in Microsoft Excel.

Using the SmartTagRecognizers collection

Use the SmartTagRecognizers property of the Application object to return a SmartTagRecognizers collection.

This example displays the first smart tag recognizer item available for the application or displays a message that none exist.

Sub CheckforSmartTagRecognizers()

    ' Handle run-time error if no smart tag recognizers exist.
    On Error Goto No_SmartTag_Recognizers_In_List

    ' Notify the user of the first smart tag recognizer item.
    MsgBox "The first smart tag recognizer is: " & _
        Application.SmartTagRecognizers.Item(1)
    Exit Sub

No_SmartTag_Recognizers_In_List:
    MsgBox "No smart tag recognizers exist in list."

End Sub