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