mulitiple droplist

[jinvictor]

what can i do if i want different droplist in a same column when i
choose different condition.
for example:

a1 australia, china, england

b1 drop list with different cities in that country.

when i choose australia in a1, then droplist in b1 only shows australia
cities.
when i choose china in a1, only chinese cities droplist show in b1
.....

thanx

 

[Norman Jones]

Hi Jinvictor,

See xlDynamic's Dependent Dropdowns page at:

http://www.xldynamic.com/source/xld.Dropdowns.html

See also Debra Dalgleish at:

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

 

[paul]

you can also do this with form combo boxes.the source list for your dropdown
box are vlookup formulas looking back at a table with your countries in the
top row,cities in the columns below with the lookup values just being 12345
etc in the first column