Worksheet.FollowHyperlink event (Excel)

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


expression.FollowHyperlink (Target)

expression An expression that returns a Worksheet object.


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


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

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) 
    With UserForm1 
        .ListBox1.AddItem Target.Address 
    End With 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.