How do you create a chained select list in excel? Chained Selects lets you
"chain" multiple form select lists together so that the selection in a
"parent" list can tailor the options available in a "child" list.

I want to "chain" three select lists and have prepared options for them.
It's just like mapping a three-level folder tree to three select lists, the
folders/items at top-level will populate the first select list, and when a
top-level folder is selected, its sub-folders/sub-items will populate the
second select list, and same goes for the third select list.

hide

Perhaps through using dependent Data Validation drop-down lists.

See Debra Dalgleish's site for info.

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


Gord Dibben Excel MVP

On Fri, 20 May 2005 11:52:09 -0700, "hide"
wrote:

How do you create a chained select list in excel? Chained Selects lets you
"chain" multiple form select lists together so that the selection in a
"parent" list can tailor the options available in a "child" list.

I want to "chain" three select lists and have prepared options for them.
It's just like mapping a three-level folder tree to three select lists, the
folders/items at top-level will populate the first select list, and when a
top-level folder is selected, its sub-folders/sub-items will populate the
second select list, and same goes for the third select list.