Google Maps Static API in Excel

[waimea]

I have crossposted this at https://www.excelforum.com/excel-for...ml#post4962202

I am trying to add a loop with makers on code from this page: ' I am unable to post links here

I would like to loop through a list or a file with markers and place them onto the map.

Dim i As Integer
Dim url As String
For i = 1 To 25

'code here to loop through list, file or array?
url = 
https://maps.googleapis.com/maps/api/staticmap?center=



'append city, size, markers to url

Next i

I would also like help with how to create a select case statement:

Select case City
Case Is Stockholm
'code here to loop through markers for Stockholm
Case is Oslo
 ' code here to loop through markers for Oslo<br>
End select

I would like help with how to set up gUrl.

Example.
Baseurl is : https://maps.googleapis.com/maps/api/staticmap?center=

City is Stockholm and is a named range called selected_city

zoom is 10 and in a named range called zoomLevel

How do I correctly add the selected_city and the zoomLevel to the baseurl??