View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ivankamastelic@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Immediately jump to next cell?

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!