Is this possible ? Automatic cell entry

T

Tatebana

I have to ad up in individually in cells innumerable amounts, unfortunately I
have to jump from one cell to the other, put the cursor at the end of the
already entered formula (something like this: 67+45+2+89+7897+124457+5+2154)
press "+" and the additional amount.

Is there a Private Sub that would add the plus-sign whenever I select a cell
and press a certain simple key?
 
R

Ragdyer

You might try hitting <F2> after clicking in a cell.
Then just hit +, and enter the new value.
 
M

MartinW

Hi Tatebana,

May or may not be what you are looking for.
At the bottom of the screen just above the windows taskbar is an excel
bar (forgotten it's name). Right click on this bar and make sure sum is
ticked.
Then select a cell, hold down the ctrl button and continue to select cells
the
bar will show a progressive total of all the cells you select.

HTH
Martin
 
Top