Addition using Visual Basic - Help!

[Tomkinson]

I would like to place a number into a cell and have it be added to a running total in another cell when you click a button.
So say you type a number into B3, once you click the 'button' it takes that number and adds it on to the number already in C3 and clears cell B3. Anyone know how to do this? Felt like it would be simple task but it's been too long since I last used VB it would seem...

 

[VoG]

Try assigning this to a button

Sub AddC3()
Range("C3").Value = Range("C3").Value + Range("B3").Value
Range("B3").ClearContents
End Sub

 

[Tomkinson]

Try assigning this to a button

Sub AddC3()
Range("C3").Value = Range("C3").Value + Range("B3").Value
Range("B3").ClearContents
End Sub

Thank you very much, I knew it would be simple. Too many beers since College had washed it from my mind.