Trigger Macro when cell changes

[neodjandre]

I am trying to fire a macro only when the cell value inside a specified range changes (i.e. not selected but actually changed in value).

I am using this code but it fires every time a cell is selected.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("mynames"), Range(Target.Address)) Is Nothing Then
x_admin.Range("operation") = Target.Range("A1").Value2
End If
End Sub

 

[Norie]

Use the Change event.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Application.Intersect(Range("mynames"), Range(Target.Address)) Is Nothing Then
        x_admin.Range("operation") = Target.Range("A1").Value2
    End If
End Sub

 

[neodjandre]

ok, I have figured this out as well, thanks norie