may work.. but this is the official way:
application.Dialogs(xlDialogFormulaFind).Show
From help: (Built-In Dialog Box Argument Lists)
xlDialogFormulaFind text, in_num, at_num, by_num, dir_num, match_case,
match_byte
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
"Jim Cone" wrote:
Bridget,
I can't find it either in the "Built-In Dialog Box Argument Lists" in
the vba help file. However, the following code does bring it up...
Application.CommandBars.FindControl(ID:=30003).Con trols
("Find...").Exec
ute
Regards,
Jim Cone
San Francisco, CA
"Bridget" wrote in message
...
If
Application.Dialogs(xlDialogPrint).Show
brings up the print dialogue box in E2K, can someone pls
tell me what brings up the Find box? I did a search for
this on the net, but nothing came up. I guess I don't
know how to search for general VB coding like this; I
don't even know if there is a resource out there for
hunting down VB code (?).
Thanks so much!