worksheet_change not working

[JChandler22]

Hi all,

My worksheet_change code is not working at all, and I can't figure out why. I've tested even the most basic worksheet_change code, and it's still not firing:

Private Sub Worksheet_Change(ByVal Target As Range)

    MsgBox "You changed " & Target.Address

End Sub

Am I missing something blatant in the code here, or is there an excel setting that's not configured correctly? All of my other macros are working fine.

Thanks in advance,
Jeff

[davegugg]

I copied your code verbatim and it works fine for me. What are you expecting? It fires whenever you change a cell in the sheet, not when you change from one sheet to another.

[JChandler22]

Yes, that's exactly what I'm expecting, and strangely it's not happening for me. When I change any cell in this one sheet, nothing happens. No message box. Thanks for trying - let me know if you have any more suggestions...

[romperstomper]

How are you changing the cell? Manually or as the result of a formula? (the former will work, the latter won't).
You can also open the VBEditor (Alt+f11) then the Immediate Window (Ctrl+G) and type in:

Application.EnableEvents = True

and press enter.

[teylyn]

Are macros enabled?
Is the code in the Sheet module?
Is the code in the correct Sheet module?

Just asking ....