Share via

Name.CategoryLocal Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  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

See Also