View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Craig[_3_] Bill Craig[_3_] is offline
external usenet poster
 
Posts: 1
Default Please help me get this accumulator working

I've read everything in this group about how to get an accumulator
going. Here's my task:

DailyClosingEntry SummaryClosingEntry
Cash Cash
Credit Credit
Etc. Etc.

Here's the code I'm trying:

(in the DailyClosingEntry Worksheet module)

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Address(False, False, , False) = _
Worksheets("DailyClosingEntry").Range("C5") Then
If IsNumeric(.Value) Then
Application.EnableEvents = False

Worksheets("SummaryClosingEntry").Range("C5").Valu e= _

Worksheets("DailyClosingEntry").Range("C5").Value+ .Value
Application.EnableEvents = True
End If
End If
End With

End Sub

Result: Nothing in the SummaryClosingEntry cell. What am I doing
wrong?

Thanks in Advance.