Hello All,

Having got to a point with a more specific query it was suggested that I re-post, the solution for which I guess may be useful in other applications:

I am looking for a way to force data entry to be completed by hitting the return key.

My application for this is that my custom data validation does not work unless a user hits return having entered their data. If they instead use the cursor to click elsewhere on the sheet they are able to violate the rule.

I have read along similar lines of being able to disable the use of the fill handle and drag-and-drop, but this isn't quite what I need.

Any ideas anyone?

Many thanks in advance.


Simon.