Hello
I would like to ask you if i have two comboboxes how i rstrict the values of
the second one given a specific value in the first one.

E.g

1st combobox contains
China
Australia

2nd Combobox
Beijing
Shanghai
Guangdong
Tangsham
Tianjin
Adelaide
Perth
Sydney


If i choose for example australia in the 1st combobox

i want the second one to drop down only Adelaide, Perth and Sydney

Could please help me to sort this out

Thanks in advance

Angeliki

Here is information on doing this for a Data=Validation combobox which
would work as well with a combobox from the forms toolbar. If you are using
an activeX combobox, then you would need to establish the second list based
on an event fired from the first combobox.

From Debra Dagleish's site
http://www.contextures.com/xlDataVal02.html


--
Regards,
Tom Ogilvy


Angeliki wrote in message
...
Hello
I would like to ask you if i have two comboboxes how i rstrict the values
of
the second one given a specific value in the first one.

E.g

1st combobox contains
China
Australia

2nd Combobox
Beijing
Shanghai
Guangdong
Tangsham
Tianjin
Adelaide
Perth
Sydney


If i choose for example australia in the 1st combobox

i want the second one to drop down only Adelaide, Perth and Sydney

Could please help me to sort this out

Thanks in advance

Angeliki