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

You can do this with a data validation dropdown list and programming.
There's an example he

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

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


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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thank you for the information. I will try and let you know if I am succesful.

Lynn

"Debra Dalgleish" wrote:

You can do this with a data validation dropdown list and programming.
There's an example he

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

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


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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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