Yup events were not enabled. Not sure how this happened.

Thanks

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