active macro on new value

[wonderboutin]

I want active a macro is the Range("A1") have a new value.

"A1" = (=sheet2!B1) A1 is in sheet1

if I write a new value in sheet2!B1, sheet1!A1 have a new value and i want to active macro

I try this macro

Private Sub Worksheet_Change(ByVal Target As Range)
If MY_OLD_VALUE <> Range("A1") <> Value Then
'your code here
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MY_OLD_VALUE = Range("a1").Value
End Sub

but is good if I change the value of A1 but if A1 is a copy of a other cell, then macro is not activated

tanks

 

[onlyadrafter]

Hello,

Stick to your original post

http://www.mrexcel.com/board2/viewtopic.php?t=234792

 

[wonderboutin]

I try the 2 macro on the other topic but is not what I want to do.

The fist macro

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
'your code here
End If
End Sub

active my macro only if I change the value of the cell ("A1") but if the cell ("A1") is a calcule or a copy of a other cell ex: =B2,
the macro is not activated



The second macro



Private Sub Worksheet_Change(ByVal Target As Range)
If MY_OLD_VALUE <> Range("A1") <> Value Then
'your code here
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MY_OLD_VALUE = Range("a1").Value
End Sub



active my macro if any value in the sheet in changed not only cell ("A1")