Home » Blogs » Thomas Collins's blog

Calling a website and returning

Submitted by Thomas Collins on 16 December, 2012 - 14:42

Thanks Andy that does work.
Instead of dropping a hyperlink onto th worksheet, and executing from there, I'd prefer to have it execute directly from the User Form upon clicking on the option. In other works, click and the button and it directly goes to the website, then returns to the user form (same one or next) without having to return to the spreadsheet itself. Make sense?
Pat

»

Thanks, Andy, your tweak

Submitted by Thomas Collins on 27 December, 2012 - 00:26.

Thanks, Andy, your tweak worked like a charm!! Wow.

Humm... will have to think of something a little tougher for you next time!
Appreciate it!
TC

»

Try this one Private Sub

Submitted by AndyLitch on 17 December, 2012 - 14:44.

Try this one

Private Sub Label1_Click()
Dim Link As String
Link = "http://en.wikipedia.org/wiki/Main_Page"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub

»