Hi everyone,

I've seen some old threads about this issue but I couldn't find a solution.
this is my problem:
I have a list with values that users select from and this field has data validation over it.
the problem is that the users tend to paste their values to make the process faster and by that deleting the validation.
I would like to let them paste values to this field but only the specific values that are in the list.

I'm pretty new in VB so if anyone could help with a simple code it would be great!

thank you so much!