Hi guys,


when I plug a "Defined Names" into a "Data Validation" list, the Data Validation's "Error Alert stops"

I want to be able to use "Defined Names" in "Data Validation" and have error alerts appear to the user, if the cell isn't an entry found within the Defined Names.

Any ideas?
Thanks!