Thank you for visiting ITKE.
We are happy to help you with solving specific IT questions, but need as
much information as possible to do so. Let us know about the problem you
are trying to solve, how you are approaching it and what work you’ve
done so far, and we can help guide you in the right direction.
Here are pointers towards a simple solution. In the change event code for the paricular worksheet object, check for the location of the Target range parameter. If this is the desired range (say cell A1) then load another cell with global variant storing old value and then update global variant.