VBA Textbox

Ok, Thanks!

"Steve Rindsberg" wrote:

> In article <D824F820-A44E-4A9A-9BD2-B9C68D7FA7B5.DeleteThis@microsoft.com>, Alexf wrote:
> > Thanks!
> >
> > But one question, What does "Strip Out" mean?
>
> 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 '
>
> > So, how would you write
> >
> > If Right$(Me.TextBox1.Text, 1) = "=" Then
> >
> > in code?
>
> Um. That IS the code.
>
>
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
>
>
>

ok, but how do you get the slide to advance

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

=?Utf-8?B?QWxleGY=?= <Alexf.TakeThisOut@discussions.microsoft.com> wrote in
news:95172A9E-1842-40A4-B96D-A038B1F10653@microsoft.com:

> 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

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

In article <95172A9E-1842-40A4-B96D-A038B1F10653.TakeThisOut@microsoft.com>, Alexf wrote:
> ok, but how do you get the slide to advance
>
> (say you type in "LEGAL", then what do you do? press enter?)

Type an "=" character (or change the code so it's something else).



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

In article <Xns9AD4724E19846marcoNOSPAMloyolaedu.RemoveThis@207.46.248.16>, David M.
Marcovitz wrote:
> =?Utf-8?B?QWxleGY=?= <Alexf.RemoveThis@discussions.microsoft.com> wrote in
> news:95172A9E-1842-40A4-B96D-A038B1F10653@microsoft.com:
>
> > 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.

And thanks back to you for noticing that. That alone makes it a better buy to
type in names rather than numbers. Nice catch, David.


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
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================