Hello,
I've spent quite a bit of time researching this, but haven't found anything super helpful.
Goal: Execute macro on cell value change.
Current: Executes macro on target cell selection
Any ideas? Happy Monday!
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$E$8:$G$8" Then Sheets("Account Details").Range("ExpirationDate").Formula = "=IF(E8="""","""",DATEVALUE(MONTH(E8)&"" / ""&DAY(E8)&"" / ""&(YEAR(E8)+1)))" End If End Sub