Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum cells using command button ADD
How to add values in a1,a2 and a3 cells and to show the result in a4 only by
clicking a command button inserted from the tools box. I want the simple codes step by step. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum cells using command button ADD
In design mode, double-click on the button, and in the window that appears, put the code
Private Sub CommandButton1_Click() ' This may have number other than 1 appended Range("A4").Value = Application.Sum(Range("A1:A3")) End Sub HTH, Bernie MS Excel MVP "Dr.H.Subramanian" wrote in message ... How to add values in a1,a2 and a3 cells and to show the result in a4 only by clicking a command button inserted from the tools box. I want the simple codes step by step. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print 20 cells with a command button | Excel Discussion (Misc queries) | |||
Using Command Button to copy cells | Excel Discussion (Misc queries) | |||
Deleting some cells in a row using command button and offset | Excel Programming | |||
Limiting the cells a command button can change | Excel Programming | |||
Non Working Cells after command button | Excel Programming |