Running total

[hevside]

Hello
Can someone please tell me if this is possible and if so how?

I enter a number in cell A1 (let's say 10)
this value displays in cell B1 (10)
when I change the number in cell A1 (to 22)
the value in B1 shows the total of the two entries (32)

each time I change the entry in A1 I would like B1 to increment by that number.

Thanks

[Domski]

Hi,

Like this:

Please Login or Register  to view this content.

Right click on the sheet tab, select view code and paste the above onto the code page that's displayed. You'll probably want to put some validation on A1 to stop the user entering text.

Dom

[Colin Legg]

Welcome to the forum.

You have to use VBA to do this. I've attached a simple example; the code in the worksheet's class module is this:

Please Login or Register  to view this content.