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
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