ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Data Validation (https://www.excelbanter.com/excel-worksheet-functions/76249-data-validation.html)

MarieB

Data Validation
 
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?
--
Marie

Debra Dalgleish

Data Validation
 
You can do this with programming. There's a sample file he

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

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


MarieB wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


MarieB

Data Validation
 
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!
--
Marie


"Debra Dalgleish" wrote:

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

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

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


MarieB wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



MarieB

Data Validation
 
Hi Debra

Spotted the change - thanks.
--
Marie


"MarieB" wrote:

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!
--
Marie


"Debra Dalgleish" wrote:

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

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

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


MarieB wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




All times are GMT +1. The time now is 06:24 PM.

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