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