application.dialogs(xldialogsformulafind).show and then some ...

[Peter]

Hello everyone,

Can someone let me know how to get the Find dialog on screen with the option
for looking in values pre-selected ?

Thanks,
Peter
Excel 2000

 

[Dave Peterson]

Like this??

Dim myStr As String
myStr = "What should I find"
Application.Dialogs(xlDialogFormulaFind).Show myStr

You can type in application.dialogs and select .dialogs and hit F1.

From there, you'll get to VBA's help.

If you drill down far enough, you'll see that this dialog has these parms:

xlDialogFormulaFind text, in_num, at_num, by_num,
dir_num, match_case, match_byte

You could seach the help for:
BuiltIn;dialog;list;
And get there quicker, too.