cell with zip only hyperlink to google maps

[Cattle]

I have a column in excel with all the zip codes in Missouri. I want to hyperlink the individual cells to that zip codes location in google maps. Each time I do an internet search I get how to create a map in excel. That is not what I want to do. Any help appreciated.

 

[Anthony47]

Try this code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
myZipCol = 2        '<<<The column with Zip codes; 1=A, 2=B, ...
If Not Application.Intersect(Target, Columns(myZipCol)) Is Nothing Then
    ThisWorkbook.FollowHyperlink ("https://maps.google.com/?q=Zip " & Target.Value & " usa")
    Cancel = True
End If
End Sub

You need to copy it to the vba module that belongs to the worksheet:
-rightclick the tab with the name of your worksheet; chose Display code (this will open the macro editor at the right position)
-copy the given code and paste it to the empty right frame of the macro editor
-edit the line marked <<< according your situation

Then return to the worksheet and doubleclick a cell with a zip code.
It will work even if you doubleclick on a cell that contains anything, but the searched site will be an "approximate search" if it isn't a zip code

Bye