G Guest Feb 23, 2006 #1 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?
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 Feb 23, 2006 #2 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.
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.
