View Single Post
  #3   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

Thank you for your suggestion, but I don't think that website explains
exactly what I am looking for.

It's not that I need three drop-downs, A B & C, where the selection in A
determines B and the selection in B determines C.

Instead, I need the selection in A to determine B & C.

For instance, if the first validation list has France and Great Britain, and
I choose France, there is just one dependent drop down, listing Paris, Lille,
Avignon, etc. But if I choose Great Britain, there should be two drop downs,
one listing cities in England (London, Manchester etc) and one listing cities
in Scotland (Edinborough, etc). The user would need to choose cities in both
England and Scotland, but those choices would not affect each other. Does
that make sense?

"Eduardo" wrote:

Hi Caroline,
Take a look to Debra Web she has the solution you are looking for

http://www.contextures.com/xlDataVal02.html

If this was helpful please click yes, thanks

"Caroline" wrote:

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