command button to calculate two cell values?

[sunil5]

Hi,

Probably an easy one for most...

I've got a command button and I would like it so when I press it, i
calculates the values in cells "D8" and "D9" and puts the total i
"D10"


Any help would be much appreciated.

Thanks

 

[Tom Ogilvy]

Private Sub CommandButton1_Click()
Range("D10").Value = Range("D8").Value + _
Range("D9").Value
End Sub

 

[anilsolipuram]

In the design mode double click the button

and paste this code

Private Sub CommandButton1_Click()
Range("d10").Value = Range("d8").Value + Range("d9").Value
End Sub

 

[sunil5]

Oh thanks for that- i was trying to use the Range command but not
properly.

Cheers again