(Msg. 1) Posted: Wed Sep 03, 2008 1:45 pm
Post subject: VBA: "Replace" dialog box filled with values but not run Archived from groups: microsoft>public>powerpoint (more info?)
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"
(Msg. 2) Posted: Wed Sep 03, 2008 1:45 pm
Post subject: Re: VBA: "Replace" dialog box filled with values but not run [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum