embedded dynamic interactive menus in powerpoint presentation mode linked to Exc

[Incredulous Dreamer]

What I'd like to do is have interactive menus within a powerpoint
presention. For instance, A question followed by a pulldown menu with 5
choices. Once the choice is made, that response is linked to a spreadsheet
file (preferred) or database. In this way by going through the various
slides and selecting the responses the spreadsheet data is populated and
saved.

OK, I realize this might be a complex request, but before I get too obsessed
with this concept I'd like comments concerning;
1) Is it possible using tools within powerpoint/Excel?;
2) What methods would be best;
3) Anyone already done something similar that I can work from?

I found a "live notes" application made by Sonia Coleman which is a step in
the right direction but doesn't have the functionality I am looking to
acquire.

Thoughts?

Thanks to all in advance!


Regards,
-Ed

 

[David M. Marcovitz]

As Steve said, this is almost definitely possible, but it will take a lot
of VBA work to get it to work. I have much simpler quizzes on my site
that might point you in the right direction. However, my quizzes use
regular autoshape buttons, not pull-down menus, for answers.
Additionally, my quizzes keep track of the answers either in PowerPoint
itself or by writing to an external text file (see the More Tricks
section of my site). I believe that Shyam (http://skp.mvps.org/) has some
stuff on his site about populating combo boxes (pull-down menus). I know
that others have done some stuff to have PowerPoint communicate with
Excel, but I can't remember who off the top of my head. So, all you have
to do is pull together these three elements, and you will have what you
want.
--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/

 

[Incredulous Dreamer]

David and Steve,

Thank you! This points me in the right direction and more importantly,
inspires. I believe this method would be usefulfor many people.

David, it looks like I should pick up your book. It is definitely
appropriate for my task....and much more relevant.....than the text I bought
last night.

Steve, thanks for the pointer to those specific examples.

It does look like if I put these elements together I can make this work. I
only wish I had more talent as I only generate code myself when I must do so
to bring a vision forward.

I will plug away at this and let you know all how it goes.

Any more comments/ thoughts are appreciated

Dr Edward L. Principe

Focused Ion Beam Applications Developer, North America

Carl Zeiss SMT Inc.

Nano Technology Systems Division