Data Validation

[MarieB]

I would like to use data validation to populate entries into a cell, however,
I 'd like to be able to enter multiple entries from the list into one cell.
Is this possible?

 

[Debra Dalgleish]

You can do this with programming. There's a sample file here:

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

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

 

[MarieB]

Hi Debra
The sample file this points to seems to answer a different question, I
cannot find how this allows the input of multiple 'answers' into one cell.

Saying that, I loved what this sample file does also!

 

[MarieB]

Hi Debra

Spotted the change - thanks.
--
Marie

Hi Debra
The sample file this points to seems to answer a different question, I
cannot find how this allows the input of multiple 'answers' into one cell.

Saying that, I loved what this sample file does also!