I created a dropdown list with 20 different options.

If a value that doesn't exist is entered into the cell with the list, an
error message appears. This works perfect!

My problem is the folowing: If a value that doesn't exist in the list is
pasted into the cell that contains the list. The value is displayed in the
cell, and no error message occurs. How do I generate an error for this
scenario??

Please Help