C
chris_manning
Is it possible in Excel, either through Combo Boxes in VB or the Dat
Validation method to do a hierarchical list selection (List tree)? Fo
instance, if I have a cell, and when I click on it, the user can selec
one of several colors, and then when a selection is highlited (o
clicked) it brings up another list next to the original list of foo
items, and then depending on that selection, another list of eatin
utencils (this is a silly example, but I think it communicates m
question). Further, no matter what option is selected from the firs
two lists, it brings up the same list for the next selection.
ex:
blue
red
purple
yellow->waffles
green tacos->fork
fish spoon<-
steak knife
then, it would enter into cells A1-3, respectively, yellow, waffles
and spoon.
Any help is appreciated
Validation method to do a hierarchical list selection (List tree)? Fo
instance, if I have a cell, and when I click on it, the user can selec
one of several colors, and then when a selection is highlited (o
clicked) it brings up another list next to the original list of foo
items, and then depending on that selection, another list of eatin
utencils (this is a silly example, but I think it communicates m
question). Further, no matter what option is selected from the firs
two lists, it brings up the same list for the next selection.
ex:
blue
red
purple
yellow->waffles
green tacos->fork
fish spoon<-
steak knife
then, it would enter into cells A1-3, respectively, yellow, waffles
and spoon.
Any help is appreciated