The simplest way would be to assign a macro to your button such as:-

Sub Button1_Click()
Range("A3") = Range("A1") + Range("A2")
End Sub


"Dr.H.Subramanian" wrote:

How can I add values in 2 cells using a command button
Example - Values in A1 and A2 to be added and shown in A3 at the click of a
command button (ADD) which is inserted from the tools box.