View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
gbpg gbpg is offline
external usenet poster
 
Posts: 58
Default 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