| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find macro
Hello,
I would like to assign a macro to a button which opens the "find" box, but stops there. Ie, I want the user to enter the data they wish to find. I've tried the following code from a previous question about this but although it brings up the find box, whatever I search for always returns no results. (Doing the seach manually works fine). Application.Dialogs(xlDialogFormulaFind).Show Am I putting this in the wrong place? Should there be extra code? I'm using a Mac, by the way... perhaps there is a way to send the keys "Apple+f"? Cheers, Rich. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find macro
Activesheet.Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show or select a specific range you want to search Columns(3).Select Application.Dialogs(xlDialogFormulaFind).Show -- Regards, Tom Ogilvy "Richard Hocking" wrote in message ... Hello, I would like to assign a macro to a button which opens the "find" box, but stops there. Ie, I want the user to enter the data they wish to find. I've tried the following code from a previous question about this but although it brings up the find box, whatever I search for always returns no results. (Doing the seach manually works fine). Application.Dialogs(xlDialogFormulaFind).Show Am I putting this in the wrong place? Should there be extra code? I'm using a Mac, by the way... perhaps there is a way to send the keys "Apple+f"? Cheers, Rich. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find macro
Excellent, all sorted!
Thanks, Rich. "Tom Ogilvy" wrote: Activesheet.Cells.Select Application.Dialogs(xlDialogFormulaFind).Show or select a specific range you want to search Columns(3).Select Application.Dialogs(xlDialogFormulaFind).Show -- Regards, Tom Ogilvy "Richard Hocking" wrote in message ... Hello, I would like to assign a macro to a button which opens the "find" box, but stops there. Ie, I want the user to enter the data they wish to find. I've tried the following code from a previous question about this but although it brings up the find box, whatever I search for always returns no results. (Doing the seach manually works fine). Application.Dialogs(xlDialogFormulaFind).Show Am I putting this in the wrong place? Should there be extra code? I'm using a Mac, by the way... perhaps there is a way to send the keys "Apple+f"? Cheers, Rich. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro-find and sum | Excel Discussion (Misc queries) | |||
| Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
| change error message when no more for "find" in macro to find | Excel Programming | |||
| Using Find in a macro | Excel Discussion (Misc queries) | |||
| I need to find a macro to find data cut and paste to another colu. | Excel Programming | |||
Linear Mode
