ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data Validation Multiple Select List? (https://www.excelbanter.com/excel-programming/275893-re-data-validation-multiple-select-list.html)

Bernie Deitrick[_2_]

Data Validation Multiple Select List?
 
justice,

You can only enter items from the list. If there are combinations, then you would need to have those combinations already in the
list.

As an alternative, you could use multiple validated cells and concatenate the values using a formula in a non-validated cell.

HTH,
Bernie
Excel MVP


"justice" wrote in message ...
Please help with this problem.
I have a column range set for data validation and I am using the List.
I need to have multiple items from the list input in various cells.
My list will only allow one selection per cell. How do I get an entry
of multiple selections from the list that are input in the cell?





All times are GMT +1. The time now is 01:48 PM.

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