How do I set up a search macro in Excel?

J

Jacaara

I'm trying to set up a macro that users will click on to start searching my
spreadsheet for specific data. How do I do it?
 
D

Dave Peterson

Why not just use ctrl-f or edit|find or click on the binocular like icon?

But you could just pop up that Edit|Find dialog with a macro like:

Option Explicit
Sub testme()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

You may want to try Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

It has a lot of nice features.
 
Top