![](https://cdn-0.access-excel.tips/wp-content/uploads/2014/12/feature_excel_vba-150x150.jpg)
This Excel VBA tutorial explains how to get value before Worksheet_Change event.
Problem with getting value before Worksheet_Change event
When we use Worksheet_Change event, the event is triggered after we edit a Cell (even no value is changed). For example, when A1 value is 10, we double click range A1 to change value to 20. As we press enter, Worksheet_Change event is triggered. As you can see, the old value 10 is not stored anywhere, but sometimes we do need the old value to do calculation....
Read More