mikeoly
06-03-2019, 07:36 AM
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
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