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? |
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 |
All times are GMT +1. The time now is 06:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com