Another trick, but I don't have the code to hand, is to pre-pend the cell's
comment box with the cell's old value each time it changes. Then you can
have a journal of all changes to that cell. You could add a time stamp to
each entry if that's useful.


"wim hoevenaren" wrote in message
...
In VB I want to write a script that provides me with the row and column
information of a changed cell.
This can be done with
worksheet_change(ByVal Target as Range)

Target.row and Target.column provides the row and column information of
the changed cell. Target.value provides me with the new updated cell
value.

However, I also want to have the previous cell value of the changed
cell. How can I get this previous cell value?

Regards

wim.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!