| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to have a macro simply issue the "find" command or "control f:
I would like to have a button in my worksheet to issue the find or control F
command. This would put all the controls I need at the users fingertips. I am trying to record the macro but it will not let me stop until I perform a search which I want the user to define what text is being sought. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to have a macro simply issue the "find" command or "control f:
in the button click event try this
Application.SendKeys "^f" "Charles Adams" wrote: I would like to have a button in my worksheet to issue the find or control F command. This would put all the controls I need at the users fingertips. I am trying to record the macro but it will not let me stop until I perform a search which I want the user to define what text is being sought. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to have a macro simply issue the "find" command or "control f:
Another method:
Application.Dialogs(xlDialogFormulaFind).Show HTH "Charles Adams" wrote: I would like to have a button in my worksheet to issue the find or control F command. This would put all the controls I need at the users fingertips. I am trying to record the macro but it will not let me stop until I perform a search which I want the user to define what text is being sought. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to have a macro simply issue the "find" command or "contro
Would you know how to have the find command within a cell?
"quartz" wrote: Another method: Application.Dialogs(xlDialogFormulaFind).Show HTH "Charles Adams" wrote: I would like to have a button in my worksheet to issue the find or control F command. This would put all the controls I need at the users fingertips. I am trying to record the macro but it will not let me stop until I perform a search which I want the user to define what text is being sought. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
| macro use of "find" command | Excel Programming | |||
Linear Mode
