How to validate Data....
Posted by Ramki on January 03, 2001 12:03 PM
I am trying to paste a value into a cell containing a
list of pulldown values. The value is being pasted is not
within the range of pulldown values.
If I try to edit the value in the cell containing the pulldown
values, and new value being entered is not within the
acceptable range, then an error message pops up.
But when the value is being pasted, and is not withing the
acceptable range, no validation takes place.
How did I trigger this validation when we paste a value into
the cell containing pulldown values.
Please help me with an idea.......
THanks in ADvance,
it is in the acceptable range.