how to display the Find dialog in VBA

Topic

New Reply

Hello.

Can anyone tell me how to display the Excel2k Find (or Replace) dialog using VBA? I expected to be able to use:

Application.Dialogs(xlDialogFind).Show

but it seems that constant doesn’t exist. Now what?
Many thanks,
Robin

Reply | Quote

Replies

I can’t find it myself, much to my surprise.

The Word equivalent is wdDialogFileFind, but I can’t find the Excel equivalent.

Now what? Build your own userdialog I guess- unless it’s hiding under a different name.

I’ve been less than impressed with using some of the built-in dialog boxes myself, and have had to build my own just because of bugs and the inability to communicate with some values as documented.

Reply | Quote

OK Geoff, thanks for the advice. All the same, you’d think there would be *some* way to reproduce the effect of a simple click on the ‘binoculars’ button, using VBA. Hmm..

Reply | Quote

Application.Dialogs(xlDialogFormulaFind).Show

or

Application.Dialogs(xlDialogFormulaReplace).Show

Which I got from this handy list: Built-In Dialog Box Argument Lists

Reply | Quote

Thanks very much James.

Reply | Quote

It takes Microsoft to be so counter-intuitive.

Make sure that all named arguments work as documented before depending on it.

Reply | Quote

yep, they are the best

Reply | Quote