CategoryLocal Property

Applies To

Name Object.

Description

If the name refers to a custom function or command, this property returns or sets the category for this name as a string in the language of the user. Read-write.

See Also

Category Property, MacroType Property.

Example

This example displays, in the language of the user, the function category of a custom function or command created on a Microsoft Excel version 4.0 macro sheet. The example assumes that the custom function name or command name is the only name in the workbook.

With ActiveWorkbook.Names(1)
    If .MacroType <> xlNone Then
        MsgBox "The category for this name is " & .CategoryLocal
    Else
        MsgBox "This name does not refer to" & _
            " a custom function or command."
    End If
End With