Open Search and replace dialog

[jkrons]

Is the a way to open the Search and replay dialog?

Application.Dialogs(xlDialogSearch).Show

opens the Filesearch task, and I haven't been able to locate any
xldialog keyword for the search and replace.

Jan

 

[Ryan H]

Go to Excel help and type this in the search box: XlBuiltInDialog Enumeration

this will give you a list of all dialog boxes in Excel. Hope you can find
what you need there.

 

[dragan opric]

you have to pass a parameter

Globals.ThisAddIn.Application.Dialogs(Excel.XlBuiltInDialog.xlDialogFormulaReplace).Show("")