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"