how do you create labels that hyperlink on forms

G

gbpg

I know in Access I can create labels in forms that hyperlink to where ever I
want. Can you do this in Excel forms?
 
D

Dave Peterson

Like in a userform?

You can add a label to the userform. And use its click event:

Option Explicit
Private Sub Label1_Click()
ThisWorkbook.FollowHyperlink Address:="http://www.microsoft.com"
End Sub

You could even format the text in that label to look more like a hyperlink
(blue/underlined).
 
G

gbpg

Cheers,Thanks I will try.

Dave Peterson said:
Like in a userform?

You can add a label to the userform. And use its click event:

Option Explicit
Private Sub Label1_Click()
ThisWorkbook.FollowHyperlink Address:="http://www.microsoft.com"
End Sub

You could even format the text in that label to look more like a hyperlink
(blue/underlined).
Click to expand...
 
Top