ScreenTip Property
Returns or sets the ScreenTip text for the specified hyperlink. Read/write String.
Remarks
After the document has been saved to a Web page, the ScreenTip text may appear (for example) when the mouse pointer is positioned over the hyperlink while the document is being viewed in a Web browser. Some Web browsers may not support ScreenTips.
Example
This example sets the screen tip for the first hyperlink on the active worksheet.
ActiveSheet.Hyperlinks(1).ScreenTip = "Return to the home page"