View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default VB coding for showing "find" dialogue box?

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!