0 out of 1 rated this helpful - Rate this topic

Worksheet.FollowHyperlink Event (Excel)

Office 2010

Office 2013

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.

VBA

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) 
    With UserForm1 
        .ListBox1.AddItem Target.Address 
        .Show 
    End With 
End Sub

Concepts

Worksheet Object Members

Worksheet Object

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Worksheet.FollowHyperlink Event (Excel)

Parameters

Concepts

Community Additions

Office 2013

Office Extensibility

Resources

Connect

Developer Centers

Information for