TextToDisplay Property
From Microsoft Excel Visual Basic
TextToDisplay Property
Returns or sets the text to be displayed for the specified hyperlink. The default value is the address of the hyperlink. Read/write String.
Example
This example sets the text to be displayed for the first hyperlink on the active worksheet.
ActiveSheet.Hyperlinks(1).TextToDisplay = _
"Company Home Page"