Change in a Range

[ManUBlueJay]

I am looking for vba code that would Track if a given range changes.
The Worksheet_Change function does not work as it will react if you click into a cell even if you don't change anything.
Example my range is A1:D30
I would like E1 to Say "Changed" when a user changes anything in my range. He would be allowed to click into a cell as long as he does not change it.

 

[Joe4]

The Worksheet_Change function does not work as it will react if you click into a cell even if you don't change anything.

Worksheet_Change only reacts if a cell is manually updated (regardless of whether the value is changed).
Worksheet_SelectionChange reacts if you just select a cell.

If a user just selects a cells (moves around), Worksheet_Change will not be triggered.
So, are you saying that you users are double-clicking on a cell to get into edit mode, and then NOT changing the value (not sure why they would do that). That would trigger the Worksheet_Change event procedure.

If they are doing that, you will need to capture the cells before value and compare it to the after value.
Here is an old link that shows you how to do that: https://www.mrexcel.com/forum/excel...ba-remember-old-cell-value-before-change.html
Here is another one with various different options: https://stackoverflow.com/questions...-the-old-value-of-a-changed-cell-in-excel-vba