Hello,

I have a used a list validation in my excel sheet,
which works fine when i want to insert a value from
a specified list in a cell.

(the specific list is specified in A1:A3):
A1:YES
A2:NO
A3:NO COMMENT

but now, if i change for example in the list A3
from "NO COMMENT" to "UNSPECIFIED" i have the following
problem:
- all cells linked to the list (that now changed) where
previous "NO COMMENT" was correctly validated should
not be valid anymore since an item in my list changed.

Excel does not do this automatically. In a new cell i can
choose between the three items correctly, but what about the
old cells! they are corrupt (against my new list and excel doesn't see this!)

can i enable this autocheck on change or is there a function in vba or something that forces the validation?

what now???