Userform Textbox Contents Output to Formula

[Bench]

I'll try and make this as clear as possible, please feel free to check for clarity though.

Basically i'm building a tool that will allow users to establish the distance between two postal codes.

It works on a very simple basis, simply entering the two postcodes into a hyperlink at the appropriate place. Because of the format of the link, lots of / /'s etc i've had to split it up.

and then add it together:

leaving me with something like this:

=HYPERLINK(B2&B3&B4&B5&B6,"Get Directions")

What i would like to do i use a InputBox (though i guess a textbox inside a userform is going to be the solution) with Two Fields, Start PostCode & End Postcode, upon clicking "Ok" the hyperlink will be created and ideally followed.

In a nutshell i suppose what i need to know is how to extract the answers from an input field and add them to a generic text to form a hyperlink.

Any ideas? Is this possible?

Thanks

Ben

 

[Bench]

Managed to work it out:

Private Sub GetDirections_Click()
        Dim NextRow As Long
'   Make sure Sheet1 is active
    Sheets("Sheet3").Activate
'   Make sure a name is entered
    If TextBox1.Text = "" Then
        MsgBox "You must enter a name."
        Exit Sub
    End If
    
'   Transfer the name
    Range("L1").Select
    ActiveCell = TextBox1.Text

    If TextBox1.Text = "" Then
        MsgBox "You must enter a name."
        Exit Sub
    End If
    Range("N1").Select
    ActiveCell = TextBox2.Text
       
    ThisWorkbook.FollowHyperlink Address:=Range("P1")
    Range("A1").Select
    Unload Me
    Unload SearchBox
End Sub