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

On Thu, 24 Nov 2005 21:54:51 +0100, wrote:

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!