<sigh I hate to say it but the "official way" didn't
work either.

I used the "application.Dialogs(xlDialogFormulaFind).Show "
code and it also couldn't find anything. It seems that
these 2 sets of coding want to search _within_ whatever
cell one happens to be parked in. When I use the above
macro+button to find something that is found within that
cell, then it works, but neither will find anything found
in the whole worksheet.

Very disconcerting.

I'd still like to do this so if anyone can recommend
coding that works, I'd really greatly appreciate it.

Thanks so much!

-----Original Message-----
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!


.