| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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  -- crafty ------------------------------------------------------------------------ crafty's Profile: http://www.excelforum.com/member.php...fo&userid=3871 View this thread: http://www.excelforum.com/showthread...hreadid=512561 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 -- crafty ------------------------------------------------------------------------ crafty's Profile: http://www.excelforum.com/member.php...fo&userid=3871 View this thread: http://www.excelforum.com/showthread...hreadid=512561 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 -- crafty ------------------------------------------------------------------------ crafty's Profile: http://www.excelforum.com/member.php...fo&userid=3871 View this thread: http://www.excelforum.com/showthread...hreadid=512561 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
