formula/equation over multiple PP slides

G

Guest

Hi, I need help!
I am trying to insert a simple formula/equation into a PP presentation.

The idea is that there are 2 slides, the first 2 will include a fill in box
for the presenter to input on presentation, and the slide following will
calculate the formula needed (on click)using the data from what the presenter
inputs. If this makes any sense, and you can help me, please do!
 
D

David M. Marcovitz

This is going to require some VBA. First, you will need a way to enter
information onto a slide. This can be done with a control textbox, or it
can be done with the InputBox function of VBA. See:

Adding or entering text during a show
http://www.pptfaq.com/FAQ00701.htm

Next, you will need to calculate the answer and display it on the next
slide. This is not too difficult if you know any VBA. I have examples of
using information input during the show on a slide at my site:

http://www.PowerfulPowerPoint.com/

Example 6.6 is the first example that does this on my site.

--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
 
G

Guest

OK let me start a bit more simple. Can I do any of this from an existing
formatted slide, or should I start from a clean slide? I never heard of VBA
before I started trying to do this project today. Please feel free to
respond as though to a 2-year old :)

Thanks,
Andrea (also from Maryland :))
 
D

David M. Marcovitz

The normal features of PowerPoint do not have a way to input data during
a presentation, and they does not have a way to do something (like
calculate) based on something that is input.

The link I gave you (http://www.pptfaq.com/FAQ00701.htm) describes some
ways to get around the problem of entering the information. The simplest
of this is to go to the View menu and choose Toolbars and Control
Toolbar. From here, you can draw special textboxes on your slides (called
control textboxes). These allow the presenter to type something into the
slide. This does not require any VBA (VBA is a scripting language built
into PowerPoint that allows you to extend teh capabilities of
PowerPoint).

However, you not only want to enter information, you also want to use
that information on later slides. This does require VBA. If you have
never heard of VBA, then this project might be a bit more than you can
handle, but it is not very difficult with a little VBA knowledge. To get
started, you might look at:

Where can I learn more about VBA programming in PowerPoint?
http://www.pptfaq.com/FAQ00032.htm

--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
 
G

Guest

I'll give it a shot. And I told the boss man this is over my head, he
understands cause it's over his too :) Thanks for your help! Maybe I'll
invest some time learning VBA, looks like it could be a real asset to me in
the future.

Andrea
 

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

Top