Please help.
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!

Could be wrong but I don't think you can. By typing a number you are in
edit mode until you hit enter, and as such I don't think any code will work
for you until you come out of edit mode.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


wrote in message
...
Please help.
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!

i don't see how it's possible, either. how's excel going to know if you're
entering 1, 10, 100, 1000 and move to the next cell?

--


Gary


wrote in message
...
Please help.
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!

could this work for u'??
ok, what about in cell A1 put numbers, (ex 1234567) and when you press enter
cells A2 A3 A4 A5 A6 A7 A8 have the values 1 2 3 4 5 6 7 (or columns B C D E
F G H)
coud this work for you?????
because the coding is very easy to do so
if so write me and I send you a code to start with

" wrote:

Please help.
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!

Fact is, cell A1 to A7 (in example) will have only one number (1 or 2)
and when I press 1 or two it writes that number to a cell A1 and then
jumps to A2.
Impossible or not?

On Thu, 24 Nov 2005 15:07:04 -0800, "filo666"
wrote:

could this work for u'??
ok, what about in cell A1 put numbers, (ex 1234567) and when you press enter
cells A2 A3 A4 A5 A6 A7 A8 have the values 1 2 3 4 5 6 7 (or columns B C D E
F G H)
coud this work for you?????
because the coding is very easy to do so
if so write me and I send you a code to start with

" wrote:

Please help.
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!