launch an event when the value of a cell changes

[robertvdb]

I have this Sheet, where I want to change the backcolor of a command button, as soon as any values in range A2:A10 are CHANGED.

The issue with the code below is that the color changes as soon as any of these cells A2 through A10 are SELECTED. I don't want this, I only want a color change when the value changes.

Thanks.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i As Integer

i = Target.Row

If i >= 2 And i <= 10 Then
    
    If Target.Column = 1 Then
        CommandButton1.BackColor = RGB(100, 100, 0)
    End If
    
End If

End Sub

 

[Joe4]

Then use a "Worksheet_Change" event procedure instead of a "Worksheet_SelectionChange".
The rest of the code should be mostly the same.

 

[robertvdb]

Thanks Joe, my hero !

 

[Joe4]

You are welcome.
Glad I was able to help!