Link to URL

09-07-2004, 08:52 AM
Is there any way I can create a link to a url on a userform to open in a blank window?

Cant find anything for this?

09-07-2004, 09:10 AM
Yeap! It is possible...

There is an example:

On a user form, put on a Label. Set Font property to look like a standard Hyperlink.

In the click event of this Label put this code:

Private Sub Label1_Click()
ActiveWorkbook.FollowHyperlink Address:="", NewWindow:=True
End Sub

Hope this will help! :D

09-07-2004, 09:11 AM
You can use a label, and use its Click event to open the url:Private Sub Label1_Click()

ThisWorkbook.FollowHyperlink ""

End SubToooo slooowww

09-07-2004, 09:40 AM
I am pleased to see that I proposed the same solution than you Herilane. :D

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum