Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a search macro in Excel?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a search macro in Excel?
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. Jacaara wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Ranges in excel macro | Excel Discussion (Misc queries) | |||
Macro in Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
how to search in excel with condition | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |