BLUF: Apparently, I’m an idiot and I need help. I need to run a macro when the value in cell $O$2 changes.
I have a workbook with 100+ sheets each tracking an individual work ticket. Each sheet is exactly the same (except for work notes). I want to run a macro named, “Insert_NEW” when I hit ENTER and the cell value of $O$2 changes versus manually clicking a button to run the macro 100+ times a day. I know I’m overlooking something simple, but I’ve spent almost 4 hours trying to add this feature when it can probably be resolved in 1-2 minutes. The goal is to embed the updated script between the EnableEvent update true/false. Thank you in advance for any assistance.
I have this existing script:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 15 Then
Application.EnableEvents = False
Cells(Target.Row, 27).Value = Date + Time
Application.EnableEvents = True
End If
End Sub
I’m trying to add the script below to run the existing functional macro named “Insert_NEW”.
If Target.Address = "$O$2" Then
Call Insert_NEW
End If
I’ve also tried
If Not Intersect(target, Range("$O$2") Is Nothing Then
Call Insert_NEW
End If
Callamity is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1