Hyperlinks.Add Method

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  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.

Visual Basic for Applications 
  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