Hi Everyone.

I am having problem working w/ Worksheet event procedures. I have not done it before so I tried test it out w/ sample events. However, it does not seem the event is being triggered at all. I followed step by step:

1. Select worksheet Sheet1, right click and choose "view code"
2. Pasted the following code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$1" Then
        Application.EnableEvents = False
        If Target.Value >= 10 Then
             Range("F10").Value = True
        Else
           Range("F10").Value = False
        End If
        Application.EnableEvents = True
    End If
End Sub
3. Go to Sheet1, type 10 into Cell A1 press enter.

Nothing happens?!

I'm a bit frustrated that I could not find the reason why the event was not triggered.

The reason why I'm testing this out is also because I need to be able to flag the user if they just enter a duplicate entry or not.

Please help!