Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've got the below code:
Sheets("Data").Activate Cells.Select Application.Dialogs(xlDialogFormulaFind).Show "Hello" So when you go onto the sheet "Data" the find diallog box comes up with "Hello" in it. There are loads of instances of "Hello" on the Data sheet - how can I modify the above code, so that when the macro is run the first instance of Hello has already been found? Any help greatly appreciated Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Dialogs(xlDialogPrint).Show - prints too soon | Excel Discussion (Misc queries) | |||
Dialogs | Excel Discussion (Misc queries) | |||
Dialogs Command | Excel Programming | |||
xlDialogFormulaFind Dialog Box | Excel Programming | |||
application.dialogs(xlDialogSaveAs) AND CHDIR | Excel Programming |