t Multiple Items from Excel Data Validation List

Hi ,
As in the attached, there is a list box in column B. I want to select multiple Items from the list , and selected values should listed in the same cell separated by comma.

Could anybody advise me on this?

Hello naflas,

Data Validation does not support multiple selections. You would need to use a ActiveX ListBox control with the MultiSelect property set to 1 to make multiple selections from a list.

Many thanks for your reply,

Please find the attached , I have included a listbox, but how can I include all values in it. As in the attachment I want to include values in the coulmn K to the listbox. User may select 1 or more of them from the list box. Selected values should be listed in the same cell Separated by comma.

Many Thanks in advance

Originally Posted by Leith Ross

Hello naflas,

Data Validation does not support multiple selections. You would need to use a ActiveX ListBox control with the MultiSelect property set to 1 to make multiple selections from a list.

Hello naflas,

Before we address this further, can you use VBA macros? Often times, people can not use solutions that contain VBA.

Hello naflas,

I put together an example workbook of this. It isn't as clean looking as a Validation List because it requires a UserForm to display the ListBox. Have a look. It may or may not fit with what you want to do.