Linking Slides Information

  • Thread starter Thread starter Michael Z.
  • Start date Start date
M

Michael Z.

Is it possible for someone to input a number into one
slide and then have that number populate a slide later in
the presentation?

Thanks,
Michael
 
It can be done, but it will require some VBA programming. What exactly are
you trying to do? We might be able to provide an example that does just
what you want.
 
I want to be able to input a number and then several
slides later have this number appear in a spreadsheet
type design as a total.
 
I can think of a couple of ways to accomplish this:

1. Have a textbox control on a slide that you would type the value into.
Have a button that saves this value to some variable, then moves to the next
slide. On the desired slide, have the value of a textbox be equal to the
variable captured previously. As far as it being a "spreadsheet" design,
you might be somewhat limited. Keep in mind that PowerPoint needs to have
access to the object that you want to make equal to this value. That limits
you to what object it can be put in.

2. You could have an action button that links to Excel to easily do the
calculations. Then all you have to do is close Excel and you return to your
presentation in Slide Show mode.

If you have something that you are working on, you could zip it up and send
it directly to me and I will take a look at it (use the following link to
access my e-mail address - http://www.pttinc.com/contact.html). Also, check
out David's examples on his web site. They might provide the impetus you
need to delve into VBA!
 
Thank you very much, Bill. At this point we are going to
try to work around this another way only because I don't
know VBA. However, if we can't get around it, I may take
you up on your offer to take a quick look at it. Your
solution sounds rather simple and I think I could figure
that out. If we choose to go this route I will email you
the presentation, if you wouldn't mind, for you tell me
if that is all we would need to do. I believe that it is.

Thanks again!
Michael
-----Original Message-----
I can think of a couple of ways to accomplish this:

1. Have a textbox control on a slide that you would type the value into.
Have a button that saves this value to some variable, then moves to the next
slide. On the desired slide, have the value of a textbox be equal to the
variable captured previously. As far as it being a "spreadsheet" design,
you might be somewhat limited. Keep in mind that PowerPoint needs to have
access to the object that you want to make equal to this value. That limits
you to what object it can be put in.

2. You could have an action button that links to Excel to easily do the
calculations. Then all you have to do is close Excel and you return to your
presentation in Slide Show mode.

If you have something that you are working on, you could zip it up and send
it directly to me and I will take a look at it (use the following link to
access my e-mail address -
Click to expand...
http://www.pttinc.com/contact.html). Also, check
 
Back
Top