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
---