Skip to content

Latest commit

 

History

History
47 lines (31 loc) · 1.29 KB

Excel.Worksheet.FollowHyperlink.md

File metadata and controls

47 lines (31 loc) · 1.29 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Worksheet.FollowHyperlink event (Excel)
vbaxl10.chm502080
vbaxl10.chm502080
Excel.Worksheet.FollowHyperlink
c63eec19-008e-bfb5-1357-3d02426c1bab
05/30/2019
medium

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.

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

[!includeSupport and feedback]