Use a CommandButton Control for a Google Maps Hyperlink with Cell Data

Hi Board of Genius'

Can anybody help me to achieve this, at all, please?

I currently have a Hyperlink Cell (C10) which, when clicked, takes the user externally to Google maps at the address as inputted into a number of Cells:

User Cells:
B6 = "House Name / Number"
B7 = "Street"
B8 = "Town"
B9 = "County"
B10 = "Post Code"

The Hyperlink formula I have in C10 is:

Please Login or Register  to view this content.

This works fine, but I really want this to be assigned to a CommandButton Control, but just cannot figure out how to get it to work.
I played around with:

Please Login or Register  to view this content.

But Google seems to search for the +'s instead of the text - any ideas?


Thanks In advance.

Kind Regards

A Hundred views, but no replies?... Does this mean this can't be done?...

Originally Posted by bodnarj

Try below. Set up your string using CONCATENATE

=CONCATENATE($B$6,"+",$B$7,"+",$B$8,"+",$B$9,"+",$B$10) - I set this to cell B12. That way you can assign the below. It's not fancy, but it does work.

Sub gotit()
ActiveWorkbook.FollowHyperlink "https://maps.google.com/maps?q=" & Range("b12").Value
End Sub

Bang on, my friend, thank you.

The only thing I changed was just to keep the "Private Sub CommandButton1_Click()" event as opposed to the "Sub gotit()" Event, which I have no idea what it is, and it wasn't working, anyway.

Sorted, Thanks!