| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to pen the Find dialog box with a macro
How do I call up the Find dialog box in a macro and have the macro goto the
data requested in the find dialog? I've tried recording a macro and going to Find on the Edit menu and also CTRL F to bring up the diaog box but neither work. Thanks for your assistance. Jon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to pen the Find dialog box with a macro
This will bring up the find dialog...
Application.Dialogs(xlDialogFormulaFind).Show -- HTH... Jim Thomlinson "jonco" wrote: How do I call up the Find dialog box in a macro and have the macro goto the data requested in the find dialog? I've tried recording a macro and going to Find on the Edit menu and also CTRL F to bring up the diaog box but neither work. Thanks for your assistance. Jon |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to pen the Find dialog box with a macro
Jon,
Cells.Select Application.Dialogs(xlDialogFormulaFind).Show ActiveCell.Select HTH Paul ---------------------------------------- How do I call up the Find dialog box in a macro and have the macro goto the data requested in the find dialog? I've tried recording a macro and going to Find on the Edit menu and also CTRL F to bring up the diaog box but neither work. Thanks for your assistance. Jon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert "Find dialog box" edits into macro | Excel Discussion (Misc queries) | |||
| Paste to Find dialog box using a macro | Excel Discussion (Misc queries) | |||
| how do I write a macro to show the find dialog box in excel 2003 | Excel Discussion (Misc queries) | |||
| Find dialog Box | Setting up and Configuration of Excel | |||
| control of dialog macro dialog box. on open | Excel Programming | |||
Linear Mode
