Excel commands and shortcuts for Multi Language environments (Macros)

Question

Hi, Team.I am blocked. Maybe it's a trifle.We work in a multilanguage user environment. Excel (O365)&nbsp;shortcuts change depending on the language used by the user.We have defined several associated shortcuts to specific repetitive macros users intensively execute.So, for instance, Find Command in Excel (not function) in English=Ctrl+F, in Spanish=Ctrl+B.Is there any way to define inside a macro to open the "command Find" (the magnifying glass).So, we will can use the same shortcut&nbsp;regardless of the language defined in the application and avoiding conflicts or loss of resources.Any suggestion will be useful.Thanks.JVPA&nbsp;

hansvogelaar · Accepted Answer

JVPA_SP&nbsp;
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

Forum Discussion

Excel commands and shortcuts for Multi Language environments (Macros)

Share

Resources