Event code to continuously monitor change
Hi,
In the worksheet change event of the Sheet1 type the following
If Target.Cells(1).Address = "$B$1" Or Target.Cells(1).Address = "$C$1"
Then
If Sheet1.Cells(1, 2).Value < Sheet1.Cells(1, 3) Then
'macro name goes here
End If
End If
"Ybor Tony" wrote:
I need to continuosly monitor whenever the value of cell b1 equals or does
not equal the value of cell c1 and when it's not equal then run a macro. i
have found several answers here to similar questions but the code runs only
one time and will not activate again if the value changes back to equal and
then not equal again.
Thanks,
Ybor Tony
|