Open Search and replace dialog

J

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
 
R

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.
 
D

dragan opric

you have to pass a parameter

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