Can be done as Bob points out, but do you really want to do this?

Where is your "paper trail" so's you can keep track of entries?

What do you do when someone enters 9 instead of 10?

If you want to have an accumulator cell.....lotsa luck.


Gord Dibben Excel MVP

On Wed, 27 Jul 2005 22:09:01 -0700, "ahemani"
wrote:

I am fairly new to macros in general. Does anyone have an existing macro
that I can use which will auto sum the existing value in a cell with a new
value added to it......i.e. if cell B10 has a value in it of 55 and I type in
5 into cell B10 it will auto sum and leave 60 as the new cell contents ?
the actual code would really help...or just steps to do this.
thanks