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 

See also

Hyperlinks Object

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.