Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A12")) Is Nothing Then
If Range("A12").Value = "Bin1" Then Call ‘my macro’
End If
End Sub
Hi
I have the above code that triggers ‘my macro’ when the text ‘Bin1’ is entered into cell A12, and it works fine...