Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Accumulator
Hello,
It would seem what I was looking for all this time was called an accumulator. Is there some way to alter the code below to link up to a page in another workbook? In other words, a number would be typed in sheet 1 of another work book and this formula would take that number and add it and total it all the while keeping the running total. Thank you muchly. -Bad Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Address(False, False) = "A1" Then If IsNumeric(.Value) Then Application.EnableEvents = False Range("B1").Value = Range("B1").Value + .Value Application.EnableEvents = True End If End If End With End Sub |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Accumulator
This line:
Range("B1").Value = Range("B1").Value + .Value says to add the value to B1 of the same sheet. So worksheets("someothersheet").Range("B1").Value _ = worksheets("someothersheet").Range("B1").Value + .Value BadBoy wrote: Hello, It would seem what I was looking for all this time was called an accumulator. Is there some way to alter the code below to link up to a page in another workbook? In other words, a number would be typed in sheet 1 of another work book and this formula would take that number and add it and total it all the while keeping the running total. Thank you muchly. -Bad Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Address(False, False) = "A1" Then If IsNumeric(.Value) Then Application.EnableEvents = False Range("B1").Value = Range("B1").Value + .Value Application.EnableEvents = True End If End If End With End Sub -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Accumulator
Good morning,
You Sir, my wife will have your children! Thank you very much for the response. (Insert happy face here) -Bad "Dave Peterson" wrote: This line: Range("B1").Value = Range("B1").Value + .Value says to add the value to B1 of the same sheet. So worksheets("someothersheet").Range("B1").Value _ = worksheets("someothersheet").Range("B1").Value + .Value BadBoy wrote: Hello, It would seem what I was looking for all this time was called an accumulator. Is there some way to alter the code below to link up to a page in another workbook? In other words, a number would be typed in sheet 1 of another work book and this formula would take that number and add it and total it all the while keeping the running total. Thank you muchly. -Bad Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Address(False, False) = "A1" Then If IsNumeric(.Value) Then Application.EnableEvents = False Range("B1").Value = Range("B1").Value + .Value Application.EnableEvents = True End If End If End With End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accumulator Logic | Excel Discussion (Misc queries) | |||
accumulator with other than one | Excel Worksheet Functions | |||
Need help with two cell accumulator | Excel Worksheet Functions | |||
Two cell accumulator | Excel Worksheet Functions | |||
Two cell accumulator | Excel Worksheet Functions |