Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cascading dropdowns
Hi,
I have a Data sheet where the data is available as shown below. Code Name Country code City Id City Name AX Aland Islands AS 2974 Aaheim AL Albania DZ 273 Aaiun DZ Algeria AS 6289 Aalborg AS American Samoa AD 1955 Aalborg Gronlandshavn AD Andorra AD 1954 Aalborg Osthavn I would like to create two drop down controls - the first one will list all the countries from a range named "Country". The user will select a country from this drop down and based on the country code the second dropdown should list all the cities from a range named "City". Basically, I would like the two dropdowns behave like a master/details controls with the help of the CountryCode. Appreciate your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cascading dropdowns
check debra's site
http://www.contextures.com/xlDataVal02.html -- Gary Keramidas Excel 2003 "Santa" wrote in message ... Hi, I have a Data sheet where the data is available as shown below. Code Name Country code City Id City Name AX Aland Islands AS 2974 Aaheim AL Albania DZ 273 Aaiun DZ Algeria AS 6289 Aalborg AS American Samoa AD 1955 Aalborg Gronlandshavn AD Andorra AD 1954 Aalborg Osthavn I would like to create two drop down controls - the first one will list all the countries from a range named "Country". The user will select a country from this drop down and based on the country code the second dropdown should list all the cities from a range named "City". Basically, I would like the two dropdowns behave like a master/details controls with the help of the CountryCode. Appreciate your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to create cascading dropdowns in Excel | Excel Programming | |||
Cascading list box | Excel Programming | |||
cascading 3 cboboxes | Excel Programming | |||
CASCADING LIST BOX | Excel Discussion (Misc queries) | |||
how to use combo cascading box | Excel Programming |