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

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"
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