Drop Down Box with Check Box Selections

[Guest]

I am attempting to create a dropdown box in a single cell that has check
marks, for the following use:

I need to know what days of the week people are available (e.g., 1 = Sunday,
2= Monday, 3 = Tuesday, and so forth). In the drop down I would like to have
the drop down allow the user to click on the days they are available (e.g, 2,
3, 5 or Monday, Tuesday, and Thursday) and have the result in the cell be 2,
3, 4 (or Monday, Tuesday, Thursday).

Is there any way to create a drop down with checkmarks that returns a result
in the cell to this effect?

 

[Guest]

Try Debra Dalgleish's page at:
http://www.contextures.com/excelfiles.html

There's a sample file: DataValMultiSelect.zip
look for DV0017 - Select Multiple Items from Dropdown List

In Debra's sample, the sheet: CommaSeparated
illustrates what you're after ..

 

[Guest]

In Debra's sample, the sheet: CommaSeparated

illustrates what you're after ..

The above puts the selected DV items in an adjacent cell
with items separated by a comma

Try also the sheet: SameCell
which puts the selected DV items into the active cell (the DV cell itself)
with items separated by a comma

One of the above should fit you.

---