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


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=548248

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


---
Regards,
Norman



"jinvictor" wrote
in message ...

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


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile:
http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=548248

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
--
paul

remove nospam for email addy!



"Norman Jones" wrote:

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


---
Regards,
Norman



"jinvictor" wrote
in message ...

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


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile:
http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=548248