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
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
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.
Peter wrote:
>
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks