Muokkaa

Jaa

Worksheet.FollowHyperlink event (Excel)

  • Artikkeli

Occurs when you choose any hyperlink on a worksheet. For application- and workbook-level events, see the Application.SheetFollowHyperlink event and Workbook.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.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) 
    With UserForm1 
        .ListBox1.AddItem Target.Address 
        .Show 
    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.