There's sample code here for displaying scenarios based on a selection
from a data validation dropdown list.
geoff wrote:
How can a run a macro off a: 1) value in a cell 2) different values in a
combo box?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html