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


---
Regards,
Norman



"jinvictor" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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
--
paul
[email protected]
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" <[email protected]> wrote
> in message news:[email protected]...
> >
> > 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
> >
>
>
>