malik641
09-17-2005, 10:42 AM
Is is possible to display a target's old value after you have changed the Target value???
Here is an example of displaying the new value:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim R As Range
Dim RVal As Long
For Each R In Target
RVal = R.Value
MsgBox "New value is: " & RVal
Next
End Sub
How could I make this so that it would display the old value???
Here is an example of displaying the new value:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim R As Range
Dim RVal As Long
For Each R In Target
RVal = R.Value
MsgBox "New value is: " & RVal
Next
End Sub
How could I make this so that it would display the old value???