VBA Event Worksheet_Change not working

[erinmkurtz]

Ok, I have super simple code and it refuses to work. I've used this code several times before on other workbooks and has done wonderfully.

Sub Worksheet_Change(ByVal Target As Range)
If Target.Address.Value = "$A$1" Then
Call MyMacro
End If
End Sub

Application.EnableEvents = True (I've triple checked)

My References, Microsoft Scripting Runtime is checked, Microsoft Forms 2.0 Object Library is selected.

Fresh out of ideas. I've read through all of the previous posts about this issue. Any fresh suggestions?

Thanks!

 

[erinmkurtz]

Re: VBA Eveent Worksheet_Change not working

I ran the code then used Ctrl + G to get to the immediate to run the ?Application.EnableEvents. This returned the value of True. Tried changing the cell again and still the same issue. Thanks!

 

[erinmkurtz]

Re: VBA Eveent Worksheet_Change not working

I am utilizing Pivot Charts and I have a slicer changing the value of the pivot table on a separate tab. The cell that is changing is a title cell that is linked the changing filter selection. Thanks!

 

[Fluff]

Re: VBA Eveent Worksheet_Change not working

If A1 contains a formula, that is why your event is not being triggered.
Sheet_change events are triggered when you manually change a cell.

 

[erinmkurtz]

Re: VBA Eveent Worksheet_Change not working

Got it! I tried steve the fish's suggestion and that worked! "If Not Intersect(Target, Range("A1")) Is Nothing Then"

Thanks for all the help everyone!