Hi,

I have created a range of cells that use data validation to limit the users
choices to one of a list. They are allowed to enter something not on the
list, however if they do I need to change formulas in another range of cells.
Is it possible, and how, can I trap for this error/warning, then excute some
code....

Thanks
wAyne