My code works if i manually mod K9 cell value, but if the change is coming from Betangel, it isnt work.
Why?
Code: Select all
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address = "$K$9" Then
MsgBox "This Code Runs When Cell K9 Changes!"
End If
Application.EnableEvents = True
End Sub