Empty Cells if Not Pass the Validation

Hi All,
How to empty the cells if the input doesn't pass the validation.
Eg :
The entry must be 'A' or 'B'.
If user try to entry 'C', they will get error message and I want empty
that cells.
How to do that?

Thanks,

Resant

Take a look at Data Validation in XL Help.

In article <[email protected]>,
"Resant" <[email protected]> wrote:

> Hi All,
> How to empty the cells if the input doesn't pass the validation.
> Eg :
> The entry must be 'A' or 'B'.
> If user try to entry 'C', they will get error message and I want empty
> that cells.
> How to do that?
>
> Thanks,
>
> Resant