Formula Based Hyperlink Display Top Left

[ballwin]

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.

Please Login or Register  to view this content.

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?