Forcing data entry by pressing return

**Simon1185** · 10-20-2010, 03:50 AM

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.

**royUK** · 10-20-2010, 03:54 AM

What do you mean by custom data validation? Data Validation lists work when the user makes a selection and users enter or selects another cell

**Simon1185** · 10-20-2010, 08:48 AM

I'm not using a list in this case. I'm using a formula to restrict entry of a number that will take the sum of another below zero.

If I enter a number that would break that rule and press return or a directional arrow I get my error pop up as it should, but if I enter a number and use the cursor to select a cell somewhere else I can enter a number that breaks the rule without any warning.