Excel VBA multiple selection drop down data validation list

Hi,

I am hoping someone can help as I'm stuck!

I have an Excel workbook with two sheets; one that holds all the drop down data (as named ranges) and another where I have inserted my data validation lists, using the named ranges in the first sheet. So far so good.

Now comes the more tricky part (for me) in that I want the following to be available/happen:

• Selecting more than one of the items on the list
• Each additional item selected appears in the same cell, separated by a line break
• Only possible to select an item once
• Deselect item by clicking it again in the list

In addition I would like a code that enables autofit + 10 every time a cell changes (so automatic/dynamic).

I have the below code which works ok as long as I don't need to deselect anything, as that's when it goes a bit wrong;

• If there is only 1 item selected, I'm not able to deselect it
• If there are 2 or more items selected, and I deselect one, then the last character on the right on the top row disappears

Please Login or Register  to view this content.

What do I need to do to correct the code? I am guessing it could be about the LEN in the above, but I'm not clever enough to figure it out!

Thanks,
Elin

Hi Bernie,

That did the trick, thank you!
Any idea how I can incorporate the autofit + 10 every time a cell changes (so automatic/dynamic) into that code as well? I appreciate I copied a version of the code where I hadn't tried (and failed) to include that, so I only mentioned it in my OP.

Thanks,
Elin