Edit

Share via

Name.CategoryLocal property (Excel)

  • Article

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.

Syntax

expression.CategoryLocal

expression A variable that represents a Name object.

Example

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.