Interactive calculation during presentation

[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.

 

[Austin Myers]

Easiest solution might be to use an embed spread sheet.

Austin Myers
AT&W Technologies

Creators of PowerPoint add-ins

 

[Nikolaj]

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?

 

[Austin Myers]

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

 

[Nikolaj]

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?

 

[David Marcovitz]

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