Hi, this one is quite complicated.

I am working on a project with others and we have managed to create a data validation list where the user can choose multiple options.
User clicks "one"
Cell shows one
User clicks "two"
Cell shows one, two

The problem is, if the user wants to add "fourty" that is not on the data validation list, our code messes up in a weird way and repeats the last selected option several times. (Note that we have turned off the error message that shows for data that is not in the list, in excel.)

Please Login or Register  to view this content.
If you feel you need more information simply ask. I hope one of you can help.