Immediately jump to next cell?

I

ivankamastelic

I have a chart with 5 rows and in each cell will be only one number.
How to create that immediately after I insert a single number it jumps
to next cell below without even pressing enter?
Thanks in advance!
 
G

Gord Dibben

You cannot do this.

When you are entering data in a cell, Excel needs some type of signal that you
have finished with that cell.

ENTER or Tab or mouse-click or arrow out of the cell.

Code will not work while in editing mode so VBA will not get you there either.


Gord Dibben Excel MVP
 
Top