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

G

Guest

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically move to adjacent cells without hitting Enter 7
Move to next unprotected cell automatically after entering data 2
"Move selection after Enter" 3
TAB key doesn't move from cell to cell 2
Enter, tab, arrow keys aren't allowing me to move to other cells 6
How do I limit a cell to one digit and have it automatically tab? 5
how do I move cursor without tab, enter or arrow in Excel 1
one click move 1

Top