Userform code to open UK post code within Google Maps

[ipbr21054]

On my userform i have TextBox3 which the user enters the customers Post Code.

On the same userform i have a commandbutton called OpenGoogleMaps.

What i am looking for is when the command button is pressed the code looks at the entry in TextBox3 & opens that Post Code in Google Maps.

The is the current code that is on the button for opening Google Maps but not sure how to proceed.

Private Sub OpenGoogleMaps_Click()
ActiveWorkbook.FollowHyperlink Address:="https://www.google.co.uk/maps", NewWindow:=True
End Sub

So basically look in TextBox2 value = BS9 2HH
Now open BS9 2HH in Google Maps.

 

[NoSparks]

You're welcome.
PS: Post #4 is actually the solution the the question that was asked

 

[ipbr21054]

Post 4 now selected as answer