software

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--
crafty
------------------------------------------------------------------------
crafty's Profile: www.excelforum.com/member.php...foamp;userid=3871
View this thread: www.excelforum.com/showthread...hreadid=512561Try Debra's article:
www.contextures.com/xlDataVal02.html

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

quot;craftyquot; gt; wrote in
message ...
gt;
gt; I know how to create a drop down list but I don't know how to generate a
gt; sub list for each of the selections on the main list. For instance
gt; Makes of Cars (Autos) on the main list and Models for each Make on the
gt; sub lists.
gt; Can anyone help?
gt; Crafty
gt;
gt;
gt; --
gt; crafty
gt; ------------------------------------------------------------------------
gt; crafty's Profile:
gt; www.excelforum.com/member.php...foamp;userid=3871
gt; View this thread: www.excelforum.com/showthread...hreadid=512561
gt;
See www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;craftyquot; gt; wrote in
message ...
gt;
gt; I know how to create a drop down list but I don't know how to generate a
gt; sub list for each of the selections on the main list. For instance
gt; Makes of Cars (Autos) on the main list and Models for each Make on the
gt; sub lists.
gt; Can anyone help?
gt; Crafty
gt;
gt;
gt; --
gt; crafty
gt; ------------------------------------------------------------------------
gt; crafty's Profile:
www.excelforum.com/member.php...foamp;userid=3871
gt; View this thread: www.excelforum.com/showthread...hreadid=512561
gt;

Many thanks to Bob Phillips and Anne Troy. Your help is greatly
appreciated. Ian Craft--
crafty
------------------------------------------------------------------------
crafty's Profile: www.excelforum.com/member.php...foamp;userid=3871
View this thread: www.excelforum.com/showthread...hreadid=512561