Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button for PasteSpecial - Values - Transpose | Excel Discussion (Misc queries) | |||
How can I add values in 2 cells using a command button | Excel Programming | |||
sum cells using command button ADD | Excel Programming | |||
command button to calculate two cell values? | Excel Programming | |||
Non Working Cells after command button | Excel Programming |