View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Selecting Multiple items from drop down list

Not sure whether you're still onto this thread ...
but think you could also try Debra Dalgleish's sample file at:
http://www.contextures.com/excelfiles.html

Under Data Validation,
look for: DV0017 - Select Multiple Items from Dropdown List

It's a very informative sample
where several techniques are illustrated in different tabs

Since you want the "multi-selected" subjects to be
... all listed in a cell?


the best fit, IMO, is Debra's example in the tab:
CommaSeparated
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---