Performing calulations from data input during the presentation

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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/
 
Back
Top