Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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