Command button

[Exceldc7]

Can you have a command button in an excel that will open up a web page?
if so what kind of code do I use?

 

[Misca]

Here's a couple of ways to do that:

Sub FollowHyperLink()

   Range("A1").Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True


End Sub




Sub NavigateToURL()


Dim IE As New InternetExplorer
Dim URL As String


URL = "www.mrexcel.com"


With IE
    .Navigate (URL)
    .Visible = True
End With


End Sub

The first one opens a hyperlink from your workbook. Supereasy to use if you have the hyperlink on your workbook (if the hyperlink is not located in the active sheet make sure to add the sheet name to the code as well).

The next one opens a new Internet Explorer and navigates to the given URL. Make sure you have selected the Microsoft Internet Controls reference (Tools / References in the VB Editor) when using this one.

 

[Exceldc7]

Im having issues with this. I couldn't find the Microsoft Internet option. I'm will to do it either way. Do I have to remove the command button part and put sub hyperlink part. It actually looks like the code is find. Just doesn't go to the web page

 

[Worf]

Worked for me.
At the VBE / Tools / References window should be a line called Microsoft Internet Controls. Check it and run the Navigate macro.
If you do not get a compile error, this means the reference is correct.
If a IE window does not open, you have some other problem...