View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Caroline Caroline is offline
external usenet poster
 
Posts: 183
Default How to create 2 dependent drop down lists from 1 original drop dow

I am creating a form where users make a selection from a drop-down list.
Depending on their selection, there are either one or two dependent drop-down
lists. I know how to do one dependent drop-down, but am not sure how to have
two separate lists dependent on one original selection.

For instance, from the orginal drop down, if there are selections A, and B,
how do I get it so that if they choose A, there is one drop-down from which
they need to make a follow-up selection. But if they choose B, there are two
different follow up drop-downs to select from?

Thank you