SpreadsheetGear 2023
Add Method (IHyperlinks)


SpreadsheetGear Namespace > IHyperlinks Interface : Add Method
Specifies the range which the hyperlink will be attached to.
Specifies the address of the hyperlink (such as "https://www.spreadsheetgear.com/").
Specifies the sub address of the hyperlink (such as "Sheet1!MyDefinedName").
Specifies the screen tip to display when the mouse hovers over the range.
Specifies the text to display for the hyperlink.
Returns a newly created hyperlink with the specified options.
Syntax
'Declaration
 
Function Add( _
   ByVal anchor As IRange, _
   ByVal address As System.String, _
   ByVal subAddress As System.String, _
   ByVal screenTip As System.String, _
   ByVal textToDisplay As System.String _
) As IHyperlink
'Usage
 
Dim instance As IHyperlinks
Dim anchor As IRange
Dim address As System.String
Dim subAddress As System.String
Dim screenTip As System.String
Dim textToDisplay As System.String
Dim value As IHyperlink
 
value = instance.Add(anchor, address, subAddress, screenTip, textToDisplay)
IHyperlink Add( 
   IRange anchor,
   System.string address,
   System.string subAddress,
   System.string screenTip,
   System.string textToDisplay
)

Parameters

anchor
Specifies the range which the hyperlink will be attached to.
address
Specifies the address of the hyperlink (such as "https://www.spreadsheetgear.com/").
subAddress
Specifies the sub address of the hyperlink (such as "Sheet1!MyDefinedName").
screenTip
Specifies the screen tip to display when the mouse hovers over the range.
textToDisplay
Specifies the text to display for the hyperlink.

Return Value

The newly created hyperlink.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IHyperlinks Interface
IHyperlinks Members