VBA: "Replace" dialog box filled with values but not run

Hello,
I know how to use replace function in VBA to have some text replaced by some
other text;
but I can't find a way in VBA to show the Find&Replace dialog box with
"replace text" and "with text" boxed filled in by my macro

For example I want a user to clic on a button in a bar (and, of course, I
know how to create it) and to see the dialogue box with replace "Milan" with
"Rome" (these values must be writte in by the macro) but having the
opportunity to clic on "Replace" or "Replace all" or "Find next"

Thanks
Cosimo - Milan, Italy

Steve
Wed Sep 03 09:27:38 CDT 2008

In article <#IPYKqbDJHA.1628@TK2MSFTNGP02.phx.gbl>, Cosimo wrote:
> Hello,
> I know how to use replace function in VBA to have some text replaced by some
> other text;
> but I can't find a way in VBA to show the Find&Replace dialog box with
> "replace text" and "with text" boxed filled in by my macro
>
> For example I want a user to clic on a button in a bar (and, of course, I
> know how to create it) and to see the dialogue box with replace "Milan" with
> "Rome" (these values must be writte in by the macro) but having the
> opportunity to clic on "Replace" or "Replace all" or "Find next"

Either use SendKeys to send the appropriate keystrokes to the dialog box
(generally not a good idea) or create your own user form to mimic the existing
Search/Replace dialog box ... you can make it do anything you like in that
case.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com