Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring up the "find and replace" window
When the workbook is opened, I'd like to be prompted to search and
replace. I know that the "macro" needs to be saved as a "Workbook_open" subroutine. But I don't know how to get it then prompt for the string to be searched for. The macro recorder records nothing when I hit Ctrl+F. What's the code for bringing up the Search and replace window? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring up the "find and replace" window
does this help?
Application.Dialogs(xlDialogFormulaFind).Show -- Gary wrote in message oups.com... When the workbook is opened, I'd like to be prompted to search and replace. I know that the "macro" needs to be saved as a "Workbook_open" subroutine. But I don't know how to get it then prompt for the string to be searched for. The macro recorder records nothing when I hit Ctrl+F. What's the code for bringing up the Search and replace window? Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring up the "find and replace" window
On Jul 26, 3:58 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
does this help? Application.Dialogs(xlDialogFormulaFind).Show -- Gary wrote in message oups.com... When the workbook is opened, I'd like to be prompted to search and replace. I know that the "macro" needs to be saved as a "Workbook_open" subroutine. But I don't know how to get it then prompt for the string to be searched for. The macro recorder records nothing when I hit Ctrl+F. What's the code for bringing up the Search and replace window? Thanks,- Hide quoted text - - Show quoted text - Thanks Gary -- yes that worked. 1) How would I go about figuring this out myself -- other than asking this newsgroup? 2) I'm trying to limit the scope of the search to column H. so, I did this: Columns("H:H").Select Application.Dialogs(xlDialogFormulaFind).Show But it searches in the whole sheet. How can I limit the search to just column H? Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bring up the "find and replace" window
i'm guessing you'll have to make your own. create a form with 2 textboxes. one
with what you want to search for and one with what you want to replace it with. then search vba help for the find method, when you find what you're looking for in textbox1, replace it with textbox2. -- Gary wrote in message oups.com... On Jul 26, 3:58 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote: does this help? Application.Dialogs(xlDialogFormulaFind).Show -- Gary wrote in message oups.com... When the workbook is opened, I'd like to be prompted to search and replace. I know that the "macro" needs to be saved as a "Workbook_open" subroutine. But I don't know how to get it then prompt for the string to be searched for. The macro recorder records nothing when I hit Ctrl+F. What's the code for bringing up the Search and replace window? Thanks,- Hide quoted text - - Show quoted text - Thanks Gary -- yes that worked. 1) How would I go about figuring this out myself -- other than asking this newsgroup? 2) I'm trying to limit the scope of the search to column H. so, I did this: Columns("H:H").Select Application.Dialogs(xlDialogFormulaFind).Show But it searches in the whole sheet. How can I limit the search to just column H? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
How do you Find and Replace the word "and" but not the and in "han | Excel Discussion (Misc queries) | |||
How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) |