View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Resant Resant is offline
external usenet poster
 
Posts: 23
Default 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