software

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?

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:
www.mvps.org/dmcritchie/excel/getstarted.htm

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

It has a lot of nice features.
Jacaara wrote:
gt;
gt; I'm trying to set up a macro that users will click on to start searching my
gt; spreadsheet for specific data. How do I do it?

--

Dave Peterson