hyperlink - userform

T

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
 
D

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
 
Top