ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I add values in 2 cells using a command button (https://www.excelbanter.com/excel-programming/334749-how-can-i-add-values-2-cells-using-command-button.html)

Dr.H.Subramanian[_2_]

How can I add values in 2 cells using a command button
 
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.

bigwheel

How can I add values in 2 cells using a command button
 
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.



All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com