Hi nivek,
Yes. When the CommandButton "cmdGo" is clicked, the following code will
open an IE window and navigate to the URL entered in the TextBox "txtURL":
Private Sub cmdGo_Click()
On Error GoTo ErrHandler
ThisWorkbook.FollowHyperlink txtURL.Text
ExitRoutine:
Exit Sub
ErrHandler:
MsgBox "Invalid URL. Please try again.", _
vbExclamation, "Invalid URL"
Resume ExitRoutine
End Sub
Enter this code in the code behind the Worksheet which contains your
controls. To do that, just right-click the sheet tab and select View Code,
then copy/paste this code into the code window.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
nivek wrote:
Is it possible to open a new instance of internet explorer with a
command button and pass it an address from an text box in excel? If
so, can someone please give an example of syntax?
TIA,
nivek