This example displays the name of style one in the active workbook, first in the language of the macro and then in the language of the user.
With ActiveWorkbook.Styles(1)
MsgBox "The name of the style is " & .Name
MsgBox "The localized name of the style is " & .NameLocal
End With