Thread
:
mulitiple droplist
View Single Post
#
3
Posted to microsoft.public.excel.misc
paul
Posts: n/a
mulitiple droplist
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
Reply With Quote