Run Macro when value changes

[dfenton21]

Hi All,

Using VBA, I can create a macro that runs another macro when a cell is manually changed. Is it possible to create a macro that runs another every time a formula result changes.

Thanks

 

[VoG]

Here's an example of monitoring A1. The code goes in the sheet's code module.

Dim OldVal As Variant

Private Sub Worksheet_Calculate()
If Range("A1").Value <> OldVal Then
    OldVal = Range("A1").Value
    Call MyMacro
End If
End Sub

 

[dfenton21]

Excellent, thank you.