Excel has no way of knowing you are finished with a cell until you Tab,
Enter or arrow out of that cell.

Using VBA you still have to somehow let Excel know you are done with a cell.

So.....................I will say there is no method.


Gord Dibben MS Excel MVP

On Mon, 10 Aug 2009 09:24:01 -0700, Doug
wrote:

Actually, it appears that I was not clear in my post. Respondents have
competed a paper questionniare. We are now manually entering the data and I
am looking for a way for our data entry people to quickly enter the data with
as few keystrokes as possible.

"Gary''s Student" wrote:

Consider using a Data Validation pull-down. All the user has to do is point,
click, and select.

It also really helps to avoid input errors.
--
Gary''s Student - gsnu200860


"Doug" wrote:

Does Excel allow data to be entered without using the Enter, tab or arrow
keys to move to the next cell? I have some survey data to enter and would
like to have each survey question's response entered into each subsequent
cell. But it doubles the keystrokes to hit Enter after each question. I
would like to be able to enter, for example, "1" for male and automatically
be moved to the next cell to enter "5" for the age.