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/
 

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

Back
Top