Vba for RunningTotal

[agzil]

Hello All,

I'm still very new to vba. Pardon me for my misgiving!
I've already tried searching and tried to have it make sense but have no luck

Capture.PNG

So here is what i'm trying to do. B2 have already been set to a specific value. I need to add B2 and A3. The total will be at B3. Like in the picture 5+1=6, 6+1=7, you get the picture. I want it to run every time I add a "coin" or add a value to column A. Also if I delete the value on A8, then B8 will clear.
*I'm planning on adding this to an add button of a userform.

I appreciate all the help!

[pjwhitfield]

you dont need VBA

In B3

Please Login or Register  to view this content.

And drag it as far down as you want

[agzil]

I'm sorry, I forgot to mention that I'm tucking this to a add button of a userform..