| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Empty Cells if Not Pass the Validation
Take a look at Data Validation in XL Help.
In article . com, "Resant" 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get rid of empty cells when displaying Data validation list | Excel Discussion (Misc queries) | |||
| Data validation and empty cells | Excel Discussion (Misc queries) | |||
| Data validation and empty cells | Excel Programming | |||
| Empty Cells in validation List | Excel Worksheet Functions | |||
| Validation List with Variable Lengths & Invisible Empty Cells | Excel Programming | |||
Linear Mode
