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,

does this help?

Application.Dialogs(xlDialogFormulaFind).Show


--


Gary


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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,
>

On Jul 26, 3:58 pm, "Gary Keramidas" <GKeramidasATmsn.com> wrote:
> does this help?
>
> Application.Dialogs(xlDialogFormulaFind).Show
>
> --
>
> Gary
>
> <ex...@shoenfeltconsulting.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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,

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Jul 26, 3:58 pm, "Gary Keramidas" <GKeramidasATmsn.com> wrote:
>> does this help?
>>
>> Application.Dialogs(xlDialogFormulaFind).Show
>>
>> --
>>
>> Gary
>>
>> <ex...@shoenfeltconsulting.com> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>>
>>
>> > 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,
>