Multiple selections from a pick list - only unique selections (no repeats) ?

I posted that other thread, and I guess the way I am trying to do it is via VB.net which is why it doesn't work when I try to code it in Excel.

That said, how can I do this in VBA? I have the following code in VBA which allows for multiple selections from a pick list - but it doesn't parse if the item has been chosen already, which means that a user can pick the same item several times. I'd like it that if the user selects the same choice again, it doesn't add it to the list of chosen things, (rather it does nothing - or maybe removes it from the chosen list?)

Additionally I was thinking to see if I could order the objects.

As an example, say I have a pick list of items A, B, C, D.

First I select A:
Chosen: A

Select B:
Chosen: A, B

Select C:
Chosen: A, B, C

Select B:
Chosen: A, C

Select A:
Chosen: C

Select B:
Chosen: B, C

Is something like this possible? Thanks for any help.

In this demo I take a comma seperated list that is out of order and contains duplicates ... the resulting comma seperated list is in order and contains no duplicates...Is that what you looking for ?

Please Login or Register  to view this content.

That sounds almost *exactly* what I'm looking for. Let me try it and I'll get back to you.

Thank you for your time and help!