Worksheet.FollowHyperlink Event

  • Article
Excel Developer Reference

Occurs when you click any hyperlink on a worksheet. For application- and workbook-level events, see the SheetFollowHyperlink event.

Syntax

expression.FollowHyperlink(Target)

expression   An expression that returns a Worksheet object.

Parameters

Name Required/Optional Data Type Description
Target Required Hyperlink A Hyperlink object that represents the destination of the hyperlink.

Example

This example keeps a list, or history, of all the links that have been visited from the active worksheet.

Visual Basic for Applications 
  Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    With UserForm1
        .ListBox1.AddItem Target.Address
        .Show
    End With
End Sub

See Also