I don't think you can - that's not the way it's meant to work.

Drop downs are to select one option from the list, not multiple
selections. You would need to have a number of drop down boxes and
then CONCATENATE the results in another cell.

HTH

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=517773