Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a1+a2=a3 How can I change a2,keep old a2 value & increase a3
I want to use less columns as possible. I want others to be able to change
one column while previous values are added to increase a3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
a1+a2=a3 How can I change a2,keep old a2 value & increase a3
This example uses only two cells: A1 & A2
Insert the following code in the wroksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub Application.EnableEvents = False Range("A2").Value = Range("A2").Value + Range("A1").Value Application.EnableEvents = True End Sub Whenever a value is entered in A1, its added into A2 -- Gary''s Student - gsnu200745 "wow" wrote: I want to use less columns as possible. I want others to be able to change one column while previous values are added to increase a3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase cell value by 1 based on another cell change | Excel Worksheet Functions | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
on click change cells color and increase a number.. | Excel Programming | |||
How do I change - increase maximum limit of the row height (409 p. | Excel Discussion (Misc queries) | |||
Value Increase/Decrease/No Change | Excel Worksheet Functions |