'Declaration

 

Public Overloads Function Add( _

   ByVal destinationAddress As String, _

   ByVal topLeftCellAddress As String, _

   ByVal bottomRightCellAddress As String, _

   Optional ByVal textToDisplay As String, _

   Optional ByVal tooltip As String _

) As Hyperlink

'Usage

 

Dim instance As HyperlinkCollection

Dim destinationAddress As String

Dim topLeftCellAddress As String

Dim bottomRightCellAddress As String

Dim textToDisplay As String

Dim tooltip As String

Dim value As Hyperlink

 

value = instance.Add(destinationAddress, topLeftCellAddress, bottomRightCellAddress, textToDisplay, tooltip)

public Hyperlink Add( 

   string destinationAddress,

   string topLeftCellAddress,

   string bottomRightCellAddress,

   string textToDisplay,

   string tooltip

)

Parameters

destinationAddress

The address that corresponds to the Hyperlink's destination. This can be the Address of a Cell, an external document, a website or an email address.

topLeftCellAddress

The Address of the Cell that corresponds to the top left corner of the Hyperlink's active range.

bottomRightCellAddress

The Address of the Cell that corresponds to the bottom right of the Hyperlink's active range.

textToDisplay

The Cell’s text, if it is different from the existing one. The default value is null.

tooltip

The tooltip text that will be displayed on mouse over.

Target Platforms: Windows 11, Windows 10, 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

Reference

HyperlinkCollection Class
HyperlinkCollection Members
Overload List