| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data Validation does not work when selecting another cell.
I have a cell with data validation rules set. When an invalid entry is typed
in and the Enter key pressed, the rules work fine and reject the entry. However, if an invalid entry is typed in and the another cell is selected with the mouse (without pressing Enter), the invalid data is accepted in the cell. Is there any way of stopping this ? Thanks Simon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation | Excel Worksheet Functions | |||
| data validation list drop down text format too small | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Discussion (Misc queries) | |||
Threaded Mode
