How to trigger macro when formula result changes

[braindiesel]

I have a macro I want to run whenever a certain cell changes.

Here is the code I am using now

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "mydest" Then
myhyperlink
End If
End Sub

The challenge is mydest contains a formula that pulls the name to hyperlink to. The formula itself doesn't change, just the result.
Is this an easy fix?

 

[VoG]

Try

Private Sub Worksheet_Calculate()
Dim OldVal As Variant
If Range("mydest").Value <> OldVal Then
    OldVal = Range("mydest").Value
    myhyperlink
End If
End Sub

 

[braindiesel]

If you saw my original reply, forget it. This works perfectly, thank you