Hyperlinks.Add method (Excel)

Adds a hyperlink to the specified range or shape.

Syntax

expression.Add (Anchor, Address, SubAddress, ScreenTip, TextToDisplay)

expression A variable that represents a Hyperlinks object.

Parameters

Name	Required/Optional	Data type	Description
Anchor	Required	Object	The anchor for the hyperlink. Can be either a Range or Shape object.
Address	Required	String	The address of the hyperlink.
SubAddress	Optional	Variant	The subaddress of the hyperlink.
ScreenTip	Optional	Variant	The screen tip to be displayed when the mouse pointer is paused over the hyperlink.
TextToDisplay	Optional	Variant	The text to be displayed for the hyperlink.

Return value

A Hyperlink object that represents the new hyperlink.

Remarks

When you specify the TextToDisplay argument, the text must be a string.

Example

This example adds a hyperlink to cell A5.

With Worksheets(1) 
 .Hyperlinks.Add Anchor:=.Range("a5"), _ 
 Address:="https://example.microsoft.com", _ 
 ScreenTip:="Microsoft Web Site", _ 
 TextToDisplay:="Microsoft" 
End With

This example adds an email hyperlink to cell A5.

With Worksheets(1) 
 .Hyperlinks.Add Anchor:=.Range("a5"), _ 
 Address:="mailto:someone@example.com?subject=hello", _ 
 ScreenTip:="Write us today", _ 
 TextToDisplay:="Support" 
End With 

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.