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. |
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