Hi.
I'm trying to call a macro using a Worksheet_Change Event but everytime I run it nothing happens. The event itself works great and recognized that the macro doesn't exist after I tried deleting it. I've also tried testing my macro using the Immediate Window feature and everything worked as it was supposed to.
Here are my codes, thanks in advance
I'm trying to call a macro using a Worksheet_Change Event but everytime I run it nothing happens. The event itself works great and recognized that the macro doesn't exist after I tried deleting it. I've also tried testing my macro using the Immediate Window feature and everything worked as it was supposed to.
Here are my codes, thanks in advance
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$W$6" Then
Call MyMacro
End If
End Sub
Code:
Sub MyMacro()
If ThisWorkbook.Sheets("Sheet1").Range("Y8") = True Then
MsgBox "hey"
Else
Exit Sub
End If
End Sub