Excel commands and shortcuts for Multi Language environments (Macros)

Hi, Team. I am blocked. Maybe it's a trifle. We work in a multilanguage user environment. Excel (O365) shortcuts change depending on the language used by the user. We have defined several associat...

excel

Macros and VBA

Office Scripts

HansVogelaar
Jul 15, 2022
JVPA_SP

The following macro displays a slightly simplified version of the Find dialog:

Sub FindDialog() Application.Dialogs(xlDialogFormulaFind).Show End Sub

And for the Replace dialog:

Sub FindDialog() Application.Dialogs(xlDialogFormulaReplace).Show End Sub

HansVogelaar

MVP

Jul 15, 2022

JVPA_SP

The following macro displays a slightly simplified version of the Find dialog:

Sub FindDialog()
    Application.Dialogs(xlDialogFormulaFind).Show
End Sub

And for the Replace dialog:

Sub FindDialog()
    Application.Dialogs(xlDialogFormulaReplace).Show
End Sub

JVPA_SP

Copper Contributor

Jul 15, 2022

HansVogelaar : thaks very much, Hans!

So easy!

Nice day.

Forum Discussion

Excel commands and shortcuts for Multi Language environments (Macros)