D
Dermot
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 update
accordingly.
Now I'll tell you that
* this requires no VBA code
* it requires a single picture box - all the charts/tables are actuall
on other sheets
..but getting the picture box to update dynamically is hard if yo
don't know how.
Get it here
http://www.westnet.net.au/balson/ModellingExcel/VisualModelling.shtml
(menus may only work in IE, sorry, I prefer Firefox but it doesn't lik
the CSS template, and I was committed before I realised)
It's part of the site I'm building on financial modelling. Lots o
other good stuff there. And I'm not selling anything.
regards
Dermot Balso
* 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 update
accordingly.
Now I'll tell you that
* this requires no VBA code
* it requires a single picture box - all the charts/tables are actuall
on other sheets
..but getting the picture box to update dynamically is hard if yo
don't know how.
Get it here
http://www.westnet.net.au/balson/ModellingExcel/VisualModelling.shtml
(menus may only work in IE, sorry, I prefer Firefox but it doesn't lik
the CSS template, and I was committed before I realised)
It's part of the site I'm building on financial modelling. Lots o
other good stuff there. And I'm not selling anything.
regards
Dermot Balso