Open Search and replace dialog
 

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

Open Search and replace dialog
 

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.
--
Cheers,
Ryan


"jkrons" wrote:

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
.

Open Search and replace dialog
 

you have to pass a parameter

Globals.ThisAddIn.Application.Dialogs(Excel.XlBuil tInDialog.xlDialogFormulaReplace).Show("")

On Friday, November 20, 2009 7:19 AM jkrons wrote:

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

Application.Dialogs(xlDialogSearch).Show

opens the Filesearch task, and I have not been able to locate any
xldialog keyword for the search and replace.

Jan


On Friday, November 20, 2009 7:45 AM Ryan H wrote:

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.
--
Cheers,
Ryan


"jkrons" wrote: