VBA Textbox

  • Thread starter Thread starter Alexf
  • Start date Start date
A

Alexf

I there any way, say, to type in a textbox "Slide 5" and go to slide 5, and
to to type in the same textbox "Slide 6" and go to slide 6?


Thanks

Alexf
 
It's not clear to me what you are trying to do. It sounds like you want
to have the same information in a textbox on slides 5 and 6 so if you
type in either of the slides it shows up in both the slides. So, now for
my questions:

Do you want this to happen in Slide Show view or Normal/Edit view?

Do you want to use a regular textbox or a control text box?

Do you care if the solution involves VBA?

--David
 
David M. Marcovitz said:
It's not clear to me what you are trying to do. It sounds like you want
to have the same information in a textbox on slides 5 and 6 so if you
type in either of the slides it shows up in both the slides. So, now for
my questions:

Do you want this to happen in Slide Show view or Normal/Edit view?

Do you want to use a regular textbox or a control text box?

Do you care if the solution involves VBA?

--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Click to expand...

Do you want this to happen in Slide Show view or Normal/Edit view? In
SLideshow View

Do you want to use a regular textbox or a control text box? Control Textbox

Do you care if the solution involves VBA? Yes, it should in order for you
to type in "Slide 600" in kiosk mode and go to slide 600, etc


Thanks

Alexf
 
Also:

I'm not sure what the code would be, so I was wondering if someone would
help me...


Thanks


Alexf
 
Thank you; that worked fine!

another Question:

If i was to make another VBA textbox, and make it so that I type [Insert
Characters Here, e.g. marketing] and make it go to slide 16, which happens to
be marketing, is there an way I can do it with VBA?


Thanks in advance

Alexf
 
Thanks!

But one question, What does "Strip Out" mean?

So, how would you write

If Right$(Me.TextBox1.Text, 1) = "=" Then

in code?
 
Ok, Thanks!

Steve Rindsberg said:
Remove. We're forcing the user to type = to end the input into the box but you
don't want to ask PPT to go to slide 12=. It'll barf. So we remove (strip)
the trailing = sign from the text.

But don't worry about it, that bit's just a comment. VBA ignores anything that
starts with a '


Um. That IS the code.



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Click to expand...
 
ok, but how do you get the slide to advance

(say you type in "LEGAL", then what do you do? press enter?)
 
ok, but how do you get the slide to advance

(say you type in "LEGAL", then what do you do? press enter?)
Click to expand...

Actually, you don't need to hit Enter. It should advance automatically.
The TextBox1_Change procedure gets activated every time the text box
changes. So, if some types in L, it runs the procedure, doesn't match
any of the choices, and does nothing. Then someone types E, it runs the
procedure and does nothing. Once someone types the =, it checks to see
if the word preceding it is marketing or legal and goes automatically to
the correct slide. If the text before = doesn't match anything, Steve's
code says to pop up a message that says "Sorry, ..."

By the way, there is no need to type in ALL-CAPS as the testing is case-
insensitive in Steve's code.

Also, thanks Steve for picking this up as I was away for a few days.

--David
 
Back
Top