Check these VBA geocoding functions that can be used to retrieve the latitude and the longitude of a given address. The functions using the Google Geocoding API to get the necessary data from Google servers, so a valid API key is required.
Engineering and software development have one thing in common:
problem-solving!

Our recent articles
Mesoscale Modeling Of The Impacts Of Congestion And ITS Measures On Vehicle Energy Consumption And Greenhouse Gas Emissions Over Urban Road Networks
An executive summary of my Ph.D. thesis dealing with mesoscale modeling of GHG emissions in urban road networks.
Do you know how to extract chart data with VBA? If not, in this article you will learn how to avoid cases where you receive a chart but not the actual data.
Translate an IP to a physical location using this IP geolocation function directly from your Google Sheets. A free external API is used for fetching the necessary data.
What readers say
Tyler k.
After banging my head against the wall for weeks trying to figure out a better way to do things, I came across your script mWritePDFForms that takes a PDF template and creates one re-populated file per spreadsheet row. It is amazing!
Neil G.
I am writing out of the blue to say thanks – years ago, you wrote code to copy and paste charts into PowerPoint, I stumbled on it recently, and it has been a Godsend. An epic little bit of coding that I use all the time now, so I thought I would personally thank you!
Detlef H.
I'm a newbie in VBA. Your tutorials are the best on the web. Thanks a lot!
Emina C.
Thank you so much for this code! It works wonderfully, and it is the best I have seen so far.
170+
Articles Published
1000+
Emails Answered
700+
Comments Answered
Our main categories
Do you know how to extract chart data with VBA? If not, in this article you will learn how to avoid cases where you receive a chart but not the actual data.
Face detection in Excel? Sounds crazy, isn’t it? However, a combination of Artificial Intelligence, C#, and VBA can do this in a few seconds!
Do you know how to enhance the functionality of VBA by using an external C# console application? Sure, it is not easy but can work wonders!
Do you know how to scrape a web page and get information from all the images that it contains? Are you interested in learning how to retrieve the width and the height from a given image URL? The two macros have the answers.
Do you need a personalized solution?
If you cannot find a tutorial that fully covers your needs, contact us!
About
Hi, I am Christos Samaras, a Mechanical Engineer by profession and a Software Developer by obsession! I hold a Ph.D. degree in Mechanical Engineering, and I develop software for more than ten years.
I founded this site in 2011 to help you solve your engineering and programming problems. If you need to contact me, check this page.
I hope you enjoy your stay here!
Tips for solving Engineering & Software problems
Join our monthly newsletter and get some great tips straight to your inbox!