MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding a number to itself


Posted by Cathy on October 30, 2000 1:13 PM

If I have the number 15 in a column and then I enter the 5 how do I get the column to automatically update itself to show 20? So everytime I enter a number, I want it to add itself to the number that was there before?

Help please.

Cathy


Posted by Ivan Moala on October 31, 2000 12:02 AM

Cathy, one way to do this is via event handler
code.....The change event for the sheet.

eg. say sheet1 and the cell is A1 then use this
code;

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Static A As Double

If Target.Address = "$A$1" Then
Application.EnableEvents = False
Target.Value = A + Target.Value
A = Range("a1").Value
Application.EnableEvents = True
End If
End Sub

Ivan