Office VBA allows you to query the language used by a particular Office application. For example, executing:
? Application.LanguageSettings.LanguageID(msoLanguageIDUI)
in the immediate window will yield 1031 (German) on my system, since this is what I chose as my Office UI language.
The LanguageSettings.LanguageID property supports the following MsoAppLanguageID enum values as a parameter:
| Name | Value | Description |
|---|---|---|
| msoLanguageIDExeMode | 4 | Execution mode language. |
| msoLanguageIDHelp | 3 | Help language. |
| msoLanguageIDInstall | 1 | Install language. |
| msoLanguageIDUI | 2 | User interface language. |
| msoLanguageIDUIPrevious | 5 | User interface language used prior to the current user interface language. |