Lists and sub lists
 

I know how to create a drop down list but I don't know how to generate a
sub list for each of the selections on the main list. For instance
Makes of Cars (Autos) on the main list and Models for each Make on the
sub lists.
Can anyone help?
Crafty:confused:


--
crafty
------------------------------------------------------------------------
crafty's Profile: http://www.excelforum.com/member.php...fo&userid=3871
View this thread: http://www.excelforum.com/showthread...hreadid=512561

Lists and sub lists
 

Try Debra's article:
http://www.contextures.com/xlDataVal02.html

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"crafty" wrote in
message ...

I know how to create a drop down list but I don't know how to generate a
sub list for each of the selections on the main list. For instance
Makes of Cars (Autos) on the main list and Models for each Make on the
sub lists.
Can anyone help?
Crafty:confused:


--
crafty
------------------------------------------------------------------------
crafty's Profile:
http://www.excelforum.com/member.php...fo&userid=3871
View this thread: http://www.excelforum.com/showthread...hreadid=512561

Lists and sub lists
 

See http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"crafty" wrote in
message ...

I know how to create a drop down list but I don't know how to generate a
sub list for each of the selections on the main list. For instance
Makes of Cars (Autos) on the main list and Models for each Make on the
sub lists.
Can anyone help?
Crafty:confused:


--
crafty
------------------------------------------------------------------------
crafty's Profile:
http://www.excelforum.com/member.php...fo&userid=3871
View this thread: http://www.excelforum.com/showthread...hreadid=512561

Lists and sub lists
 

Many thanks to Bob Phillips and Anne Troy. Your help is greatly
appreciated.:) Ian Craft


--
crafty
------------------------------------------------------------------------
crafty's Profile: http://www.excelforum.com/member.php...fo&userid=3871
View this thread: http://www.excelforum.com/showthread...hreadid=512561