I've never seen that behaviour. What validation is set on the cell? What
version of Excel are you using.

Simon Jefford wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html