Change in cell content alert

  • Thread starter Thread starter PraveenVis
  • Start date Start date
P

PraveenVis

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
 
Use the Calculate event. It runs whenever the worksheet is re-calculated.

You will need to use some static variables to "remember" the results of the
previous calculation.
 
Back
Top