Share via


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:="http://example.microsoft.com", _ 
 ScreenTip:="Microsoft Web Site", _ 
 TextToDisplay:="Microsoft" 
End With

This example adds an e-mail 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

Concepts

Hyperlinks Object

Hyperlinks Object Members