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
 

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
.

Open Search and replace dialog
 

Unfortunately the first one locks finds nothingm, but locks Excel.
The second fails in line 2

Application.CommandBars("Edit").Controls("Find..." ).Execute

with an runt-time error 5: Invalid procedure call or agument.

Jan


john wrote:
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


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
 

I'm running XP / 2003 & both worked fine for me.
I am guessing by your post that you are running different platform? if this
is so, sorry but not able to assist you any further.


--
jb


"Jan Kronsell" wrote:

Unfortunately the first one locks finds nothingm, but locks Excel.
The second fails in line 2

Application.CommandBars("Edit").Controls("Find..." ).Execute

with an runt-time error 5: Invalid procedure call or agument.

Jan


john wrote:
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


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
 

I'm running XP and 2003as well, but a Danish version of Excel.

Jan

john wrote:
I'm running XP / 2003 & both worked fine for me.
I am guessing by your post that you are running different platform?
if this is so, sorry but not able to assist you any further.



Unfortunately the first one locks finds nothingm, but locks Excel.
The second fails in line 2

Application.CommandBars("Edit").Controls("Find..." ).Execute

with an runt-time error 5: Invalid procedure call or agument.

Jan


john wrote:
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


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
.


.