how do you create labels that hyperlink on forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know in Access I can create labels in forms that hyperlink to where ever I
want. Can you do this in Excel forms?
 
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).
 
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...
 
Back
Top