Dropdown list for multiple selection does not work! Need help

Hi,

I am trying to create dropdown in excel cells in a particular column and user should be able to select multiple elements. This is not working for me. So far i have done the following.

1) With a help of 'Data Validation', I was able to create dropdown which is by default single selection.
2) Next I added following VBA code,

Please Login or Register  to view this content.

3) I removed any restrictions in terms of executing the code. So, I went and enabled the option 'Enable VBA macros'

Even after ding all this, i am unable to select multiple elements in the dropdown.

Can somebody help me please?

Thank you so much for the reply.
my DV is in column N, O & P. Also, I would like to implement this in such a way that, multi-selection to be applicable for all the columns wherever the data validation is applied.

Another option?

Please Login or Register  to view this content.

Hi All,

Actually, both the options worked for me. Thanks a ton. Appreciate it.