trigger event not functioning

Originally Posted by Kenneth Hobson

Is the sheet protected?

Was a cell in column 11+ changed manually?

If the code in that sheet? Right click sheet tab, View Code.

Did an error occur?

Are macros enabled?

Try closing Excel and reopen.

No sheet not protected.
Yes unchanged cell manually
Yes macro enabled
Workbook has 10+ macro
I saved and reopened 3 times..
The event is running in other sheets..
But not this sheet..
Am I missing something?

Likely you had an error. Errors need to be handled. The way the code is written, I doubt that you want multiple iterations.

You can run Application.EnableEvents = True, close and reopen. For a one-off run of one line, I put it in Immediate window and enterkey at end.

Then use the 2nd sub here. The 1st was my test. I found 78 runs for one change.

Dim i as Integer

Private Sub Worksheet_Change(ByVal Target As Range)
    i = i + 1
    Debug.Print i, Target.Address
    If Target.Column >= 12 Then Cells(Target.Row, 14) = Target.Value
End Sub


Private Sub Worksheet_Change(ByVal Target As Range)
    On Error Resume Next
    Application.EnableEvents = False
    If Target.Column >= 12 Then Cells(Target.Row, 14) = Target.Value
    Application.EnableEvents = True
End Sub