You could use event code to do the job.

Debra Dalgleish has a sample workbook download with code.

(http://www.contextures.com/excelfiles.html)

Scroll down the page and "Select Mulitple
Items from a drop down list"


Gord Dibben MS Excel MVP

On Thu, 28 Dec 2006 09:12:01 -0800, L2Lafferty
wrote:

Can a drop down box be created to allow for multiple selections within the
list.
Example: Sales, Finance, HR, R&D, Purchasing. Can Sales, HR and Purchasing
be selected.

If Yes, how do I create.

Thanks
Lynn Lafferty
Hartford Life

Gord Dibben MS Excel MVP