Hyperlinks.Add(Object, String, Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Adds a hyperlink to the specified range or shape. Returns a Hyperlink object.

public object Add (object Anchor, string Address, object SubAddress, object ScreenTip, object TextToDisplay);

Public Function Add (Anchor As Object, Address As String, Optional SubAddress As Object, Optional ScreenTip As Object, Optional TextToDisplay As Object) As Object

Parameters

Anchor: Object

Required Object. The anchor for the hyperlink. Can be either a Range or Shape object.

Address: String

Required String. The address of the hyperlink.

SubAddress: Object

Optional Object. The subaddress of the hyperlink.

ScreenTip: Object

Optional Object. The screen tip to be displayed when the mouse pointer is paused over the hyperlink.

TextToDisplay: Object

Optional Object. The text to be displayed for the hyperlink.

Returns

Object

Remarks

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

Applies to