Returns or sets the display text for a hyperlink not associated with a graphic. Read/write String.
Remarks
This property will cause a run-time error if used with a hyperlink that is not associated with a text range. You can use code similar to the following to test whether or not a given hyperlink, represented here by myHyperlink, is associated with a text range.
If TypeName(myHyperlink.Parent.Parent) = "TextRange" Then
strTRtest = "True"
End If