Multiple Entries from Validated Data

[Justin]

On an excel spreadsheet that I have, I have a column which I want
locked so only validated data can be placed in the cells. However,
there are multiple acceptable choices (ie column 1 could include choice
a and choice c). Is there any way to allow for this?

 

[Debra Dalgleish]

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

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

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