hyperlink - userform

[tinybears]

Hey,

Is it possible to put a hyperlink in your userform. I would like to
have, that when a label is clicked, that the user is connected to a
website. Does anyone has a clue?

thx

 

[Dave Peterson]

Depending on what you have in the label:

Option Explicit
Private Sub Label1_Click()
ActiveWorkbook.FollowHyperlink "http://" & Me.Label1.Caption
'or
'ActiveWorkbook.FollowHyperlink "http://youraddresshere.com"
End Sub
Private Sub UserForm_Initialize()
Me.Label1.Caption = "WWW.Microsoft.com"
End Sub

 

[tinybears]

THX. Works like a charm!