How to open URL or local html file with command button?

[proepert]

What is the code to open a URL or local html file with a command button?

Thank you for helping me, I'm a rookie.

Excel 2000

[anwarbham]

you can create a userform and add WEB browser support and user the code

WebBrowser1.Navigate "https://www.yahoo.com"

[proepert]

you can create a userform and add WEB browser support and user the code

WebBrowser1.Navigate "https://www.yahoo.com"

Thank you for the quick reply.

In this case I don't want to use a from, just have a command button on the worksheet that I would like to open a URL.

However, because I'm learning, can you explain more about how I "add WEB browser support" to a user form? I have created a few forms, but I don't see any property or method for adding support for the WEB browser.

I'm using Excel 2000.

[anwarbham]

you can add this to the button and it will open yahoo in a new IE page

ActiveWorkbook.FollowHyperlink Address:="http://www.yahoo.com"

if you want to go down the user form page create a new user form on the controls toolbox
right click and select ADD aditional controls scroll down and select the option that says MS web browser you can now add a web browser window to the form ...

navigate via the name of the control so it will prob be called webbrowser1

so webbrowser1.navigate "web address in here "

[proepert]

Thank you very much.

[mai9]

I have a following question on this matter.

ActiveWorkbook.FollowHyperlink Address:="http://www.yahoo.com"

This works very well, but the problem is that the URL I want to open is sitting in a cell (made with the concatenate funtion). How do I add the reference in Visual Basic to make it pick the url in the A6 cell, for example?

thanks

[yussi]

I have a following question on this matter.

ActiveWorkbook.FollowHyperlink Address:="http://www.yahoo.com"

This works very well, but the problem is that the URL I want to open is sitting in a cell (made with the concatenate funtion). How do I add the reference in Visual Basic to make it pick the url in the A6 cell, for example?

thanks

you can try this:
ActiveWorkbook.FollowHyperlink Address:= Cells(rowIndex, coloumnIndex).Value