I use ByVal to notify me of any change to column 5. However, the cells in the
column 5 contain a forumla and I want to be notified of a change in the
content of the column (different outputs based on the formula)

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 5 Then
MsgBox Target.Offset(0, -4).Value & " changed", vbInformation
End If


End Sub