ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can a drop down list be set up to enable multiple selections? (https://www.excelbanter.com/excel-discussion-misc-queries/247669-can-drop-down-list-set-up-enable-multiple-selections.html)

reneeo93

can a drop down list be set up to enable multiple selections?
 
and have each selection inserted into the cell??

eg employee has a list of courses available and may want to indicate
interest in more than one....

Gord Dibben

can a drop down list be set up to enable multiple selections?
 
Yes.

See Debra Dalgleish's site for a downloadable sample workbook with event
code.

http://www.contextures.on.ca/excelfiles.html#DV0017

Note that you can have the selections in an adjacent cell or in the same
cell.


Gord Dibben MS Excel MVP

On Thu, 5 Nov 2009 13:55:02 -0800, reneeo93
wrote:

and have each selection inserted into the cell??

eg employee has a list of courses available and may want to indicate
interest in more than one....




All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com