Thread: Macro-Adding to cell value

Flow Chart:

Would like to know how to take a specific cell value, and add to another cell value, through use of a button.

Example: (working on same sheet) Sheet 1:
cell A1 + C3
then, put that value into cell C3, and zero out cell A1

Already have the button, just need to know how the syntax goes for the actual macros.

Don't know much about vba but this worked for me when i tried it. Right click the button view code then put this between your lines.

    mysum = Application.WorksheetFunction.Sum(Range("A1") + Range("C3"))
    Range("C3") = mysum
    Range("A1") = 0

that is awesomely superb, and exactly what i was looking for. thanks