Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating a cell value
What is the syntax used to update a cell value (number) by adding a value
from another cell. For example, I want cell B1 to return the value of B1 plus the inputed value of A1. In other words, I want B1 to continue to incease by the amount that I put into A1. I am using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating a cell value
Right click on your worksheet tab, select View Code and paste the following
into the code module Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target = Cells(1, 1) Then _ Cells(1, 2).Value = Cells(1, 2).Value + Target.Value Application.EnableEvents = True End Sub "Ray H." wrote: What is the syntax used to update a cell value (number) by adding a value from another cell. For example, I want cell B1 to return the value of B1 plus the inputed value of A1. In other words, I want B1 to continue to incease by the amount that I put into A1. I am using Excel 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating a cell value
See this:
http://mcgimpsey.com/excel/accumulator.html Biff "Ray H." <Ray wrote in message ... What is the syntax used to update a cell value (number) by adding a value from another cell. For example, I want cell B1 to return the value of B1 plus the inputed value of A1. In other words, I want B1 to continue to incease by the amount that I put into A1. I am using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
Link to Cell Not Updating | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel |