Hyperlinks.Add Method (Excel)

Published: July 16, 2012

Adds a hyperlink to the specified range or shape.

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.

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

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 

Community Additions

ADD
Show:
© 2014 Microsoft