Simple Change Event not working
Tom Ogilvy mentioned that you may Events Disabled.
I'm sure there is another way to enable them, but here is one way.
Sub EnableEvents()
Application.EnableEvents = True
End Sub
Run manually.
Regards,
Paul
"ExcelMonkey" wrote in message
...
It does not do anything. I just want proof that the macro is firing. And
its not firing. Even if I put a break in, it does not fire. I can't seem
to
get any examples to work. Why would this be?
EM
"JE McGimpsey" wrote:
What does your custom function MessageBox do?
When you set a breakpoint in the function, does the event macro fire?
In article ,
ExcelMonkey wrote:
I have a simple change event in Sheet1. Why is this not firing when I
type a
number greater than 100 in A1
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" And Target 100 Then
MessageBox ("Changed Value")
End If
End Sub
Thanks
|