Link to URL

suttieb
09-07-2004, 07: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?

Jamirez
09-07-2004, 08: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:="http://visualbasicforum.com", NewWindow:=True
End Sub


Hope this will help! :D

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

ThisWorkbook.FollowHyperlink "http://www.google.com"

End SubToooo slooowww

Jamirez
09-07-2004, 08: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