|  | VBA: "Replace" dialog box filled with values but not run | | |
| | | Cosimo |  |
|  Posted: Wed Sep 03, 2008 9:45 am Post subject: 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 Rindsberg | |
| | Posted: Wed Sep 03, 2008 2:27 pm Post subject: Re: VBA: "Replace" dialog box filled with values but not run | |
| |  | |
In article <#IPYKqbDJHA.1628@TK2MSFTNGP02.phx.gbl>, Cosimo wrote:
| Quote: | 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: LINK
PPTools: LINK
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
LINK |
| |
|
|
