VBA Textbox

[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

 

[John Wilson]

With vba code you could. You might also like to know that if you type eg 12
ENTER on the keyboard during a show you will go to slide 12.
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

 

[David M. Marcovitz]

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

 

[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
Microsoft PowerPoint MVP
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

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

 

[Alexf]

Also:

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


Thanks


Alexf

 

[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

 

[Alexf]

Thanks!

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

So, how would you write

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

in code?

 

[Alexf]

Ok, Thanks!

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
================================================

 

[Alexf]

ok, but how do you get the slide to advance

(say you type in "LEGAL", then what do you do? press enter?)

 

[David M. Marcovitz]

ok, but how do you get the slide to advance

(say you type in "LEGAL", then what do you do? press enter?)

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