It sounds like you used data|validation to create that dropdown list.

One way around this kind of problem is to put the validation into a worksheet
event or maybe even use a dropdown from the Forms toolbar or a combobox from the
control toolbox toolbar.



nelli wrote:

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

--

Dave Peterson