interactive presentation

[papa jonah]

I have a powerpoint file with many squares that represent various
things. For illustration sake, I would like to be able to assign
values to the color of the boxes for example Blue=2, yellow =0 green=1.
I then want to have a formula that will calculate a number based on the
colors of some boxes and then - based on the result, assign a color to
yet a different box.

When I have that done, I want to be able to click on a box to toggle
through a pre-defined color selection (blue, yellow, green). As I
toggle, I want the calculations to update the colors of the dependent
boxes.

Did that all make sense?

TIA Papa Jonah

 

[Glen Millar]

Hi,

Hmmm. Perhaps vba. Although I did something similar with Conditional
Formatting in Excel. Set the cell background to be a particular colour based
on the cell value. But clicking in PowerPoint means interactivity. Triggers
is possible too hard. better holler for a vba guru!

--

Regards,

Glen Millar
Microsoft PPT MVP

Tutorials and PowerPoint animations at
www.pptworkbench.com

glen at pptworkbench dot com

Please tell us your PowerPoint / Windows version,
whether you are using vba, or
anything else relevant

 

[David M. Marcovitz]

This is definitely a job for VBA, and based on your description, I am
pretty sure that it can be done. You will need a way to identify the
various shapes and then you can write a procedure to check certain shapes
and based on their colors set the color of other shapes. Do you know any
VBA?
--David

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

 

[papa jonah]

I am using XP and powerpoint 2003. I am not using vba although I
realize that will be necessary.
I just have no clue were to begin.
In excel I have had shapes change colors based on results of
calculations - but not the other way around.

Papa

 

[David M. Marcovitz]

To get started, check out the Programming PowerPoint section of the PPT
FAQ:

http://www.pptfaq.com/#name_PROGRAMMING_POWERPOINT

--David

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