Hi all...Here's my question:
Is it possible to create "multi-layered" drop-down lists...as in, you
click on a cell and get a drop-down list of items to select, whereby
selecting one of those items creates a "sub-dropdown" list of more
specific items in the category originally selected in the first
dropdown list?
A classic example of this would be (for you eBay listers out there) how
you select the most specific category for which to list an item...only I
would prefer to stay away from any SERIOUS programming.

Finding a solution to this will help alleviate a much greater problem
for which I am trying to find another solution for elsewhere on this
board.

Thanks in advance for the help!


--
jgn2112
------------------------------------------------------------------------
jgn2112's Profile: http://www.excelforum.com/member.php...o&userid=36175
View this thread: http://www.excelforum.com/showthread...hreadid=559570

See this:

http://contextures.com/xlDataVal02.html

Biff

"jgn2112" wrote in
message ...

Hi all...Here's my question:
Is it possible to create "multi-layered" drop-down lists...as in, you
click on a cell and get a drop-down list of items to select, whereby
selecting one of those items creates a "sub-dropdown" list of more
specific items in the category originally selected in the first
dropdown list?
A classic example of this would be (for you eBay listers out there) how
you select the most specific category for which to list an item...only I
would prefer to stay away from any SERIOUS programming.

Finding a solution to this will help alleviate a much greater problem
for which I am trying to find another solution for elsewhere on this
board.

Thanks in advance for the help!


--
jgn2112
------------------------------------------------------------------------
jgn2112's Profile:
http://www.excelforum.com/member.php...o&userid=36175
View this thread: http://www.excelforum.com/showthread...hreadid=559570

See Debra Dalgleish's site for instructions on creating dependent lists.

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


Gord Dibben MS Excel MVP

On Sat, 8 Jul 2006 00:09:44 -0500, jgn2112
wrote:


Hi all...Here's my question:
Is it possible to create "multi-layered" drop-down lists...as in, you
click on a cell and get a drop-down list of items to select, whereby
selecting one of those items creates a "sub-dropdown" list of more
specific items in the category originally selected in the first
dropdown list?
A classic example of this would be (for you eBay listers out there) how
you select the most specific category for which to list an item...only I
would prefer to stay away from any SERIOUS programming.

Finding a solution to this will help alleviate a much greater problem
for which I am trying to find another solution for elsewhere on this
board.

Thanks in advance for the help!