WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

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

 
   Home -> Office -> General Discussions RSS
Next:  Ctrl and arrow keys to go to next slide?  
Author Message
Cosimo

External


Since: Sep 03, 2008
Posts: 1



(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"

Thanks
Cosimo - Milan, Italy
Back to top
Login to vote
Steve Rindsberg

External


Since: Apr 02, 2004
Posts: 11480



(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
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Discussions 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET