Performing calulations from data input during the presentation

G

Guest

I would like to be able to use formulas during a presentation, for example
using audience-suggested numbers...

such as, asking someone :
How Old are you?
32
Input 32
Presentation calcuates they have lived for 11,680 days
 
D

David M. Marcovitz

This can be done with VBA. This particular example isn't on my Web site,
but many similar examples are:

http://www.PowerfulPowerPoint.com/

Something like (not tested so don't just copy and paste):

Sub AgeCalc()
Dim numYears
Dim numDays

numYears = InputBox("How old are you?")
numDays = Int(numYears * 365.25)

MsgBox "You are " & numDays & " days old."
End Sub

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

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