User form button to open a URL?

[frogger4]

Hi,
I'm working on simple user forms. What I would like to do is have a button that opens up a web address, when the user clicks the button. Is this related to the Hyperlink function, or one of the HTML functions (I was just looking through the Object Browser)? Or, is this even possible from a user form?

Thank you for the help, you all are great!

Private Sub Button_Click()

www.example.com

End Sub

[Dirigo]

Does something like this suit your needs?

Private Sub CommandButton2_Click()
    ActiveWorkbook.FollowHyperlink ("http://www.excelforum.com"), NewWindow:=True
End Sub

[frogger4]

Perfect, thank you!

[Srbhsomani]

Hi,

I also tried the same solution for opening google.com. Full code:

Dim link As String
link = "www.google.com"
ActiveWorkbook.FollowHyperlink Address:=link, NewWindow:=True

it says, could not open the file.

Any suggestion will be appreciated.

Thanks in advance.
Saurabh

[Srbhsomani]

Hi,

I guess the issue was with my window setting. I resolved it by following: http://support.microsoft.com/kb/218153

Thanks,
Saurabh