you could set up a separate list to drive your other input boxes and then use
a CHOOSE function, linking the choice from the first drop down to dynamically
change the input range for the second combo box
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Lisa" wrote:

Is it possible to have a selection from a combo box effect other combo boxes
in a worksheet?

I am trying to create a worksheet (in Excel, since I do not have Access)
that if I select a choice from a drop-down that would effect the options of
the other drop-downs.

Any advice would be greatly appreciated.
Lisa