Help to open a web page from a textbox

hello everyone:

Thanks for read my post.

I'm from Chile, i need your help.

Does anyone know how open the website saved from the textbox?

Is there a code for that?

II hope for his kind answers

Originally Posted by Olly

Not sure what you mean by "saved from the text box". But you could adapt something like this:

Sub foo()
    Dim stURL As String
    On Error GoTo Terminate
    stURL = InputBox("Enter URL")
    If Not Left(stURL, 4) = "http" Then stURL = "http://" & stURL
    ThisWorkbook.FollowHyperlink (stURL)
Terminate:
    If Err.Number Then
        MsgBox "Error " & Err.Number & " - " & Err.Description, _
            vbCritical + vbOKOnly, "Error"
        Err.Clear
    End If
End Sub

Thanks Olly.

when i refer to "saved from the text box" is can obtain the link that is found in a specific cells in a woorksheets. Then my idea is ejecute the userform and the user can open the link directly from textbox.

Know what I mean?

i hope your answer, thanks in advance

Originally Posted by Olly

Post a sample workbook, showing your input cell(s) and existing userform / code.

Hello Olly

Look, please attach the file relating to example need if you can help me. Basically i want to know if there some methods for open the link that found in the textbox.

---

Best RegardExample.xlsm