how can I move cells after data input without using enter or tab

I would like to set up a worksheet that allows 1 digit numerical data to be
entered into a cell and then move onto another cell automatically without
having to use the "Enter" or "Tab" or "arrow" keys

From the menu bar, select tools - options

Choose the edit tab and tick the box "move selection after enter"

you can the choose up, down, left or right from the pull down

tghcogo

oops ignore my post, I've just re-read yours, I misinterpreted it.

Mull

Cannot be done.

How would Excel know that you had finished typing if you didn't indicate in
some fashion?

Code cannot run when you are in "Edit" mode, which is the mode you are in when
entering something in a cell.


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 06:11:03 -0800, "mull" <[email protected]>
wrote:

>I would like to set up a worksheet that allows 1 digit numerical data to be
>entered into a cell and then move onto another cell automatically without
>having to use the "Enter" or "Tab" or "arrow" keys