How to run VBA code when a cell changes?

Question

I want to add VBA code when the value in the cell changes.

I already tried Worksheet_Change()as described in Contextures, however, this will not work: it only works when the user changes the value. I want to run it whenever the value changes, that is, whenever the spreadsheet is recounted.

Any ideas?

Answer 1

Private Sub Worksheet_Calculate()
   MsgBox "Something recalculated", vbOKOnly, "Testing Actions"

End Sub