Zooming and Bounds

When you click on an infobox, use a quicklink or select a category on a generated map the zoom level will change (if you have enabled it in your excel parameters.).

Click on an infobox or use a quicklink

Here I selected a single marker, and it zoomed in to the level I specified in the 'zoomlevelonselect' parameter in my geocoding parameter sheet. 

google maps zoom

Clicking on the marker again will restore to its regular size.

Select a category

In this case, it will resize according to bounding box rules, if enabled by the "resizeboundingbox" parameter. This means that it will zoom to the maximum it can but still show all selected items. For Example, here I select the category "united states". and it resizes to show the two places in US. To reset, just select all categories.

bounding box google maps


The Excel parameters

These are on the geocoding parameters sheet and look like this


See here for more about  Integrating Excel with Maps and Earth
For help and more information join our forum,follow the blog or follow me on twitter .

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.



For help and more information join our forumfollow the blogfollow me on twitter
Comments