When skipping around in a table of data to update certain cells, its quite
common for some to click into the cell, enter the new data, and then click
the next cell where data must be updated. I have found that when Validating
data at these cells, validation does not work unless you hit the ENTER key to
accept the new data.

Is there a way to either have the validation work by using the mouse
navigation method or prevent mouse navigation from switching cells before an
ENTER key is pressed?
Thanks