Name.CategoryLocal property (Excel)
Returns or sets the category for the specified name, in the language of the user, if the name refers to a custom function or command. Read/write String.
expression A variable that represents a Name object.
This example displays, in the language of the user, the function category of either a custom function or a command created on a Microsoft Excel 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.