TextToDisplay Property Example
This example sets the text to be displayed for the first hyperlink on the active worksheet.
ActiveSheet.Hyperlinks(1).TextToDisplay = _ "Company Home Page"