Worksheet.FollowHyperlink Event (Excel)

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

Syntax

식 .FollowHyperlink(Target)

식 An expression that returns a Worksheet object.

Parameters

Name	Required/Optional	Data Type	Description
Target	필수	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

참고 항목

개념

Worksheet Object Members

Worksheet Object