TIP: Dynamic chart selection without code
 

magine
* a workbook with a results sheet.
* the results sheet has a display area which shows a chart or table,
chosen by the user from a dropdown list.
* when the user chooses a different chart/table, the display updates
accordingly.

Now I'll tell you that
* this requires no VBA code
* it requires a single picture box - all the charts/tables are actually
on other sheets
..but getting the picture box to update dynamically is hard if you
don't know how.

Get it here
http://www.westnet.net.au/balson/Mod...odelling.shtml
(menus may only work in IE, sorry, I prefer Firefox but it doesn't like
the CSS template, and I was committed before I realised)

It's part of the site I'm building on financial modelling. Lots of
other good stuff there. And I'm not selling anything.

regards

Dermot Balson


--
Dermot
------------------------------------------------------------------------
Dermot's Profile: http://www.excelforum.com/member.php...o&userid=37375
View this thread: http://www.excelforum.com/showthread...hreadid=570642