Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home

"ADDING DAILY VALUE TO MONTHLY VALUE"

Posted by DALE MINKEL on February 13, 2002 1:06 PM
: OKAY, HERE'S THE SCENARIO..
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim OldValue
If Target.Address <> "$B$1" Then Exit Sub
OldValue = Range("B2").Value
Range("B2").Value = OldValue + Target.Value
End Sub


Check out our Excel VBA Resources

Re: "ADDING DAILY VALUE TO MONTHLY VALUE"

Posted by Barrie Davidson on February 13, 2002 2:47 PM

Dale, the above code worked for me. What problems did you have?

BarrieBarrie Davidson


Re: "ADDING DAILY VALUE TO MONTHLY VALUE"

Posted by Richard Winfield on February 13, 2002 3:00 PM

Code worked for me too. I wonder if possibly he still has iteration checked and set at 1?

Rick


Re: "ADDING DAILY VALUE TO MONTHLY VALUE"

Posted by Richard Winfield on February 13, 2002 3:13 PM

Well I tried that and it didn't seem to make any difference. VBA still worked correctly.

Rick


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.