Get Hyperlink Screentip to Variable

[Orada]

I have a sheet copied from the web with complete with hyperlinks, the hyperlink Screentip contains the full text of the truncated hyperlink text.

What I want to do get the hyperlink Screentip into a variable so I can use it in my intended output, so far I have been unsuccessful.

All help much appreciated.

 

[MickG]

Perhaps something like:=

Dim MyStr As String
MyStr = Range("A1").Hyperlinks(1).ScreenTip
MsgBox MyStr

 

[Orada]

Perhaps something like:=

Dim MyStr As String
MyStr = Range("A1").Hyperlinks(1).ScreenTip
MsgBox MyStr

Perfect, thank you

So much syntax, so little time...