Lat and Long inputs to Google maps

[shal_llly]

Hi!

I would like some help where when a user types in the lat and long and clicks on a button, I would like the coordinates to show up in the google maps.

Any help will be appreciated! Thank you very much

 

[mrhstn]

Here is one idea

Book1
	A	B	C	D	E
1	Place	Longitude	Latitude	Elevation	Link
2	Tuvalu	-8.54212	179.141	11	View Tuvalu On Google Maps
3	Antigua	17.0873	-61.8812	11	View Antigua On Google Maps
Sheet2

Cell Formulas
Range	Formula
E2	=HYPERLINK("https://www.google.co.uk/maps/place/"&A2&"/@"&B2&","&C2&","&D2&"z", "View "&A2&" On Google Maps")

 

[shal_llly]

Hi, i am actually looking for like a VBA macro code to do so! sorry i didnt mention it on top!

 

[mrhstn]

OK, try this

Sub GotoMaps()
    Dim Lng As Double
    Dim Lat As Double
    Dim Ele As Double
    Dim Loc As String
    
    Lng = Range("B2").Value
    Lat = Range("C2").Value
    Ele = Range("D2").Value
    Loc = Range("A2").Value
    
    ActiveWorkbook.FollowHyperlink _
      Address:="https://www.google.co.uk/maps/place/" & Loc & "/@" & Lng & "," & Lat & "," & Ele & "z", _
      NewWindow:=True
      
End Sub