Previous value and the new value of a cell.

[gpnavin86]

Hi,
I am trying to compare the cell value, old with the changed value. I am using the below code to get the new value but I was not able to get the previous value of the cell.
The new value is fetched to the variable z.

Can anyone help please.

Private Sub Worksheet_Change(ByVal Target As Range)
X = Target.Row
y = Target.Column
Z = Cells(X, y).Value

 

[pedie]

Not sure what you want you, do you mean something like this?

[/FONT]
[FONT=Courier New]Sub NEW_OLD_VALUE()
Dim X As String
Dim y As String[/FONT]
[FONT=Courier New]X = ActiveCell.Value
ActiveCell.Value = "5"
y = ActiveCell.Value
MsgBox Application.Sum(X, y)
End Sub[/FONT][FONT=Courier New]

 

[gpnavin86]

Thanks for your reply.
I will trigger a macro on change of a cell.
If a cell value is changed from 3 to 4, then a macro will get triggered.
I am able to get the cell value as 4 inside the macro.
But i don't know how to get 3(old value of a cell). So that I can compare if it changed from 3 to 4.

 

[Sandeep Warrier]

Hi

This should solve your problem.

http://www.mrexcel.com/forum/showthread.php?p=1468085

 

[gpnavin86]

Hi Sandeep,
That is what I exactly wanted.
Thanks thanks thanks a lot for your help.

Thanks,
Navin G P

 

[gpnavin86]

That code is working, but it is creating problem because the code is trying to do undo. While undo on a cell it is taking me to another sheet, this is because the the undo is trying to trigger another macro i guess..

 

[Sandeep Warrier]

Post your full code. Ideally it should not fire other events because EnableEvents is set to False.