Drop down list based on choice of another dropdown

[Amy]

A1 has a list of 4 choices
AAA
BBB
CCC
DDD
Depending on which of these I choose, I want to have te ability to choose
from another list that is associated with my first choce. How can I do this?

 

[FSt1]

hi
if you are using data validations, see this site
http://www.contextures.com/xlDataVal02.html

or if you are using sheet combo box.

if combobox1.value = "choise1" then
combobox2.rowsource = range1
else
if combobox1.value = "choise2" then
combobox2.rowsource = range2
else
if combobox1.value = "choise3" then
cobobox2.rowsource = range3
end if
end if
end if
the above is pysudo code but the principle is sound.
range1 might be something like range("A1:A5") and so on

the above is good for form combo boxes.

regards
FSt1

 

[Gord Dibben]

Dependent DV list instructions from Debra's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP