Create Drop Down List with Multiple Selection

[Rodrigo Mourinho]

Hi Experts,

I'm creating a dropdown list in excel, but as you know it only allow us to select one option.
I would like to have a list where I can choose multiple options.

I've seen a lot of postings where you can select more than one option, but without any check box.
What I'm searching for is a box simmilar to the one when we use a filter.

It is no problem to use VBA code.

Can you help me?

Thank you in advance,
Rodrigo Mourinho

 

[bobhc]

Probably the best site for data validation, this section should help you.

http://www.contextures.com/excel-data-validation-multiple.html

.

 

[Rodrigo Mourinho]

Probably the best site for data validation, this section should help you.

http://www.contextures.com/excel-data-validation-multiple.html

.

Thank you very much for the quick reply.
I've seen this post, but it seems that the solution I really want (the last one in this link) requires a payment..

 

[NARAYANK991]

Hi ,

The site lists all of the code and the features available in the free version , and it seems to me that it will do what you are looking for.

The premium version has features which you have not mentioned in your initial post.

Narayan

 

[Rodrigo Mourinho]

Hi ,

The site lists all of the code and the features available in the free version , and it seems to me that it will do what you are looking for.

The premium version has features which you have not mentioned in your initial post.

Narayan

Hi Narayan,

The thing that is missing me is the possibility of have a droplist with a check box, where I can select / Unselect. And this feature seems to me that is not in the free version.