Action when result of formula changed

[paulked]

Hi.

I am trying to run a macro when the result of a calculation changes.

A1 on Sheet1 contains =Sheet2!A1+1

I have tried Worksheet_Change event but it doesn't detect it.

Any ideas?

Thanks

[Bob Phillips]

Use the Calculate event.

[paulked]

Thanks for quick reply.

I looked at that but don't understand it. Could you give me an example please?

Many thanks

[Bob Phillips]

Something like this

[vba]

Private Sub Worksheet_Calculate()
Static PrevValue As Variant

If Me.Range("L1").Value <> PrevValue Then

MsgBox "yes"
End If
End Sub
[/vba]

[IBihy]

Hello,

in the VBEditor, click the sheet on which change you want to react. Above the code window, select "Calculate" from the drop-down, add your code in the sub. It's that easy.

HTH,
Isabella

[paulked]

Thanks xld and IBihy

[mdmackillop]

Please remember to mark your threads Solved.

[paulked]

Has the 'mark it solved' link moved? Can't find it, sorry

[mdmackillop]

If you're using Chrome it doesnt show, but it's in the usual place.