View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Open Search and replace dialog

I don't think it's available, does not appear to show in the Built-In Dialog
Box Argument Lists

However, see if one of these two approaches helps you.


Sub aaa()

Application.Dialogs(xlDialogFormulaReplace).Show

End Sub

Sub bbb()

Application.CommandBars.FindControl(ID:=1849).Exec ute
Application.CommandBars("Edit").Controls("Find..." ).Execute

End Sub

--
jb


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