Macro/VB UserFrom - Click Button, Open Browser and got to URL from textbox

[stevefisher85]

Hello,

Wondering if anyone can help me? I have a UserForm that contains a number of text boxes. One of those text boxes contains a URL. I want to find a way I can either double click the text box, or click a command button, which will open Internet Explorer and navigate to the URL contained within the textbox.

I have searched and found the below code which people say is working for them but is bugging for me at the .HyperlinkAddress = Me!txtURL line

Private Sub cmdGo_Click()

    Dim ctl As CommandButton

    Set ctl = Me!cmdGo

     If Len(ctl & vbNullString) > 0 Then

         With ctl

             .HyperlinkAddress = Me!txtURL

             .Hyperlink.Follow

         End With

     End If

End Sub

Any help on this would be appreciated. Thanks

 

[Norie]

That doesn't look like Excel VBA code to me, looks more like Access especially with the Me! syntax.

Anyway, in Excel we can use the FollowHyperlink method of the workbook.

Something like this.

ThisWorkbook.FollowHyperlink txtURL.Value

 

[stevefisher85]

You are absolutely spot on. Complete oversight trying to find a solution!! Silly mistake. Will give that a go. Thanks for the help