Multiple select from drop down

[Amadeusfrb]

I want to create a drop down list in a cell, say B5, from which the user can make MULTIPLE selections; then, the multiple selections should all be eneterd in the same ONE cell (B5).

Can I do this in Excel 2007?

[shg]

You would need an ActiveX ListBox control with MultiSelect enabled, and some code to extract and list the selected items in a cell.