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?
Cant find anything for this?
Link to URLsuttieb 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