Display user input in Powerpoint

W

Wi11y13

In Powerpoint is there a way to automatically display user input (such as a
name) on a secondary chart (such as a certificate when completing an on line
training package). I have been able to input the name but can not seem to
display ot on the last chart.

Thanks.
 
W

Wi11y13

Thank you. I now have been able to create a variable that contains the alpha
string that I need (in this case the name of the student taking the on-line
training course). What I need now is to be able to display that variable
alpha string in a text box or other means on a printable certificate which is
the last chart. Unfortunately it can not just be in a msgbox from Powerpoint
but must be displayable on the certificate. Any ideas on how to display that
variable on another chart so it is printable?

Thanks in advance.
 
D

David Marcovitz

Those examples put the text into a text box on a slide. All you have to do
is get the formatting of the slide set up the way you want it to look like a
certificate. My examples simply use a standard Title & Text slide.

I just found another example that might help you:

www.loyola.edu/edudept/facstaff/marcovitz/Certificate.ppt

It might be more similar to what you want.

--David

Thank you. I now have been able to create a variable that contains the alpha
string that I need (in this case the name of the student taking the on-line
training course). What I need now is to be able to display that variable
alpha string in a text box or other means on a printable certificate which is
the last chart. Unfortunately it can not just be in a msgbox from Powerpoint
but must be displayable on the certificate. Any ideas on how to display that
variable on another chart so it is printable?

Thanks in advance.
Click to expand...

--
David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland
 
W

Wi11y13

This is exactly what I want. I have run the example and it works perfectly
but I get an error when I run it from my presentation. I am not a programmer
so I do not understand it. It executes the first subroutine, asks for the
name and accepts it but I do not know how to associate the box I have created
with the variable that has been input. It seems to bomb on the following line:

ActivePresentation.Slides("CertificateSlide").Shapes("NameShape") _
.TextFrame.TextRange.Text = userName

I know it is trung to put the username somewhere at tthis point but again
not being a programmer I do not know how to associate hte actual text box
here. Is there something I need to set up when I create the text box?

Thanks and sorry for what I am sure are very basic questions.
 
D

David Marcovitz

Two things to note:

(1) userName is the name of the variable with the user's name. If you have
used a different variable name, put that there instead.

(2) In this code, both the slide with the certificate and the shape where
the name goes are named (CertificateSlide and NameShape, respectively). You
could substitute slide numbers and shape numbers for these names (leaving
off the quotes if you use numbers), or you can use the code in Example 8.7
on my site to name the slide and the shape (leave off the quotes when naming
the shapes).

--David

This is exactly what I want. I have run the example and it works perfectly
but I get an error when I run it from my presentation. I am not a programmer
so I do not understand it. It executes the first subroutine, asks for the
name and accepts it but I do not know how to associate the box I have created
with the variable that has been input. It seems to bomb on the following line:

ActivePresentation.Slides("CertificateSlide").Shapes("NameShape") _
.TextFrame.TextRange.Text = userName

I know it is trung to put the username somewhere at tthis point but again
not being a programmer I do not know how to associate hte actual text box
here. Is there something I need to set up when I create the text box?

Thanks and sorry for what I am sure are very basic questions.
Click to expand...

--
David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland
 
D

David Marcovitz

Thank you. Now not only does it work but now I understand it.
Click to expand...

Excellent! Now, I'll have to get you to fill out an instructor evaluation
form:)
--David

--
David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland
 
W

Wi11y13

Thank you. I now have it working but have come across 2 more questions (and
then I promise to stop). It seems every time I edit the chart package I lose
the 2 definitions that I created for the CertificateSlide and the
CertificateUserName. In order to get it to work again I need to re-select the
objects and re-run the defined macros and re-save the presentation. Is there
a way to make this permanent so I do not need to re-run these "definition"
macros each time I edit the chart package?

Also when I have saved this to a Powerpoint slide show, upon completion of
the run it asks, "do I want to save the changes". Since this will be utilized
by many people in taking this training, is there a way to eliminate this
choice at the end of the slide show presentation?

Thank you so much for your help. It has been invaluable.
 
D

David Marcovitz

I'm not sure about question 1. Do you mean that you are creating the slide
via some kind of chart package. If the slide and the shapes are getting
re-created, they would lose their names.

As for question 2, just add the line:

ActivePresentation.Saved = True

to the end of your procedure (right before the End Sub). This will fool
PowerPoint into thinking the presentation is already saved.

--David

Thank you. I now have it working but have come across 2 more questions (and
then I promise to stop). It seems every time I edit the chart package I lose
the 2 definitions that I created for the CertificateSlide and the
CertificateUserName. In order to get it to work again I need to re-select the
objects and re-run the defined macros and re-save the presentation. Is there
a way to make this permanent so I do not need to re-run these "definition"
macros each time I edit the chart package?

Also when I have saved this to a Powerpoint slide show, upon completion of
the run it asks, "do I want to save the changes". Since this will be utilized
by many people in taking this training, is there a way to eliminate this
choice at the end of the slide show presentation?

Thank you so much for your help. It has been invaluable.
Click to expand...

--
David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland
 
W

Wi11y13

So the activepresentationsaved worked.

For the other one (question #1), anytime I am in the original chart package
and make an update to any chart (not just the one that the definitions are
on) and then save the chart package (both just to PPT as well as a slide show
PPSM) the definitions seem to disappear. I go back in and re-run the define
macros, resave both PPT and PPSM again and it works - until I make anoth
change anywhere within the chart package.
 
D

David Marcovitz

Sorry, I'm not familiar with the Chart Package at all. Perhaps, someone else
can help you with this one.
--David

So the activepresentationsaved worked.

For the other one (question #1), anytime I am in the original chart package
and make an update to any chart (not just the one that the definitions are
on) and then save the chart package (both just to PPT as well as a slide show
PPSM) the definitions seem to disappear. I go back in and re-run the define
macros, resave both PPT and PPSM again and it works - until I make anoth
change anywhere within the chart package.
Click to expand...

--
David M. Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Microsoft PowerPoint MVP
Associate Professor, Loyola University Maryland
 
W

Wi11y13

Ok - I will ask it in a different question on the board. I really want to
thank you again for all of the help you have provided.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert Certificated digital signature in Word for Mac 0
Automatic hover/help texts based on Schema annotations? 0
Display weeks from a Milestone 0
Macro definitions disappear 6
Publisher is filling blank lines with data 2
Visio: copy text of a master shape to User-define Cells (Variable) 0
QBF & Query Malfunction 0
Move Chart with Text 0

Top