Hello, I was wondering if someone could help me to add the code to d
the following in a worksheet:
Assume that the sheet has current data. The user clicks on a cell (fo
example that contained the number 500) and enters the number 5 and hit
enter or tabs to another field. I would like the number 5 that wa
entered to be added to 500. Again, this would be updated by eithe
hitting enter or moving to another field.

I have attempted this, but could not get it to work. Below is my cod
if it helps anyone to understand what i am trying to do. I woul
appreciate any help...


Code
-------------------
Dim intExistVal As Integer
Dim intCellCol As Integer
Dim intCellRow As Integer
Dim temp

Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.Range(intCellCol + intCellRow).Value = Sheet1.Range(intCellCol + intCellRow).Value + intExistVal
intExistVal = Empty
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
intExistVal = ActiveCell.Value
intCellCol = ActiveCell.Column
intCellRow = ActiveCell.Row
End Su
-------------------


also, I tried using Cell(intCellCol + intCellRow) and could not get th
Cell object members to pull down after entering a following period. No
sure why this doesn't work

--
ctroy
-----------------------------------------------------------------------
ctroyp's Profile: http://www.excelforum.com/member.php...fo&userid=3532
View this thread: http://www.excelforum.com/showthread.php?threadid=55097