Worksheet_change not working

[vbakh]

For some reason in my excel worksheet_change seems to do nothing

for example the simple code below does nothing at all. Do I have something disabled that i should turn back on?

Private Sub Worksheet_Change(ByVal Target As Range)

MsgBox Target.Address

End Sub


thanks.

 

[Jonmo1]

Welcome to the board...

sounds like you have Events Disabled..

In VBA window, click view - immediate window
Type

?Application.EnableEvents
Press Enter

That will return TRUE or FALSE

If False, then the events are disabled...

Type this to enable them

Application.EnableEvents = True
Press Enter


Hope that helps.

 

[MrKowz]

If what Jonmo1 suggested does not work for you (ie your Events are already on), ensure that your code is placed in a worksheet module, and not just a regular module.