Formula Based Hyperlink Display Top Left

I wish to use a hyperlink and have the destination address display automatically at the top left of the screen. I found VBA through another thread that works well for hyperlinks created with the wizard.

Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal Target As Hyperlink)
         Application.Goto Range(Target.SubAddress), True
End Sub

However, that VBA does not work if the hyperlink is formula based.

=HYPERLINK("#"&ADDRESS(MATCH(B10,$A$1:$A$15000,0),1), "Link")

How do I use the formula and have the destination appear top left on screen?