Interactive calculation during presentation

  • Thread starter Thread starter Nikolaj
  • Start date Start date
N

Nikolaj

“On a running presentation, i´d like to enter a number in a form/box, for
example “5†then hit a button that say “Calculateâ€
The result should then show on the same page or next if necessary. The
formula I want to use for calculation is this (“entered numberâ€)2 +3) x 1,36


I´am using pp2007/vista.
 
Easiest solution might be to use an embed spread sheet.

Austin Myers
AT&W Technologies

Creators of PowerPoint add-ins
 
Yes, I have made a version with the use of "Control Toolbox/More Controls/ MS
Office Spreadsheet 11.0" - It gives me the ability to imput data during
presentation - and the calculation works, but I was looking for a way to have
a input box and a submit button on the slide instead of spread sheet with
A,B,C/1,2,3 boxes.

For example

Slide 1 - content

Enter value (box/form)

Calculate (button) press to calculate

Slide 1 update showing the result

or

Slide 2 work as a "resultpage" displaying the result of the input fro slide 1
- - -
Can it be done - any suggestions?
 
You could do it easily with a bit of VBA code (macro).


Place two textboxs (controls, not PowerPoint text) on your slide. Place one
command button (control) on the slide.

Double click the command button and insert this code.

Private Sub Commandbutton1_Click()
TextBox2 = TextBox1 * 2 + 3 * 1.36
End Sub


That should do it.



Austin Myers
AT&W Technologies

Creators of PowerPoint add-ins
 
Excellent,

Just was I was looking for - how do I obtain more knowledge about this VBA
code - books with good examples etc? Can you suggest any?
 
I think this is where I am supposed to come in and shameless hawk my
book, not because it is very good but because it is the only book about
using VBA in PowerPoint... Must...resist...urge...to...sell...books...in
newsgroup...OK. Instead you can start with the PPT FAQ
(http://www.pptfaq.com/) and click on the Programming PowerPoint link.
That will get you started.
--David
 
Back
Top