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.

expression .TextToDisplay

expression A variable that represents a Hyperlink object.

This example sets the text to be displayed for the first hyperlink on the active worksheet.

ActiveSheet.Hyperlinks(1).TextToDisplay = _ 
 "Company Home Page"
Show:
© 2015 Microsoft