Heirarchical lists

[chris_manning]

Is it possible in Excel, either through Combo Boxes in VB or the Data Validation method to do a hierarchical list selection (List tree)? For instance, if I have a cell, and when I click on it, the user can select one of several colors, and then when a selection is highlited (or clicked) it brings up another list next to the original list of food items, and then depending on that selection, another list of eating utencils (this is a silly example, but I think it communicates my question). Further, no matter what option is selected from the first 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.

[Jason Morin]

See Debra Dalgleish's site on dependent validation lists:

http://www.contextures.com/xlDataVal02.html

HTH
Jason
Atlanta, GA

"chris_manning" wrote:

>
> Is it possible in Excel, either through Combo Boxes in VB or the Data
> Validation method to do a hierarchical list selection (List tree)? For
> instance, if I have a cell, and when I click on it, the user can select
> one of several colors, and then when a selection is highlited (or
> clicked) it brings up another list next to the original list of food
> items, and then depending on that selection, another list of eating
> utencils (this is a silly example, but I think it communicates my
> question). Further, no matter what option is selected from the first
> 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.
>
>
> --
> chris_manning
> ------------------------------------------------------------------------
> chris_manning's Profile: http://www.excelforum.com/member.php...o&userid=23986
> View this thread: http://www.excelforum.com/showthread...hreadid=376944
>
>

[Dave Peterson]

Debra Dalgleish shows how to do this with Data|Validation at:
http://www.contextures.com/xlDataVal02.html

chris_manning wrote:
>
> Is it possible in Excel, either through Combo Boxes in VB or the Data
> Validation method to do a hierarchical list selection (List tree)? For
> instance, if I have a cell, and when I click on it, the user can select
> one of several colors, and then when a selection is highlited (or
> clicked) it brings up another list next to the original list of food
> items, and then depending on that selection, another list of eating
> utencils (this is a silly example, but I think it communicates my
> question). Further, no matter what option is selected from the first
> 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.
>
> --
> chris_manning
> ------------------------------------------------------------------------
> chris_manning's Profile: http://www.excelforum.com/member.php...o&userid=23986
> View this thread: http://www.excelforum.com/showthread...hreadid=376944

--

Dave Peterson