how do you create labels that hyperlink on forms
Cheers,Thanks I will try.
"Dave Peterson" wrote:
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).
gbpg wrote:
I know in Access I can create labels in forms that hyperlink to where ever I
want. Can you do this in Excel forms?
--
Dave Peterson
|