Hyperlink.TextToDisplay Property (Excel)
Returns or sets the text to be displayed for the specified hyperlink. The default value is the address of the hyperlink. Read/write String.
Syntax
expression .TextToDisplay
expression A variable that represents a Hyperlink object.
Example
This example sets the text to be displayed for the first hyperlink on the active worksheet.
ActiveSheet.Hyperlinks(1).TextToDisplay = _
"Company Home Page"