Change cell color when value changes and UNDO using VBA

[jfrad]

I am currently using the following code to change a cell's color when the value in that cell changes,

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = 6
End Sub

However, I want to be able to use the "UNDO" button to change the value back and clear the cell color.

Please advise!

 

[louisH]

Hi,

Same thread from 9 years ago :

https://www.mrexcel.com/forum/excel...-undo-after-cell-change-worksheet_change.html

 

[jfrad]

Thanks, I'll take a look! I hadn't come across that thread in my search.