topic Re: Geocode points to map using address as soon as address is entered into excel in ArcGIS for Excel Questions

Geocode points to map using address as soon as address is entered into excel

MichaelBishopp — Tue, 11 Oct 2022 14:23:18 GMT

I want to have an address geocoded in the map of ArcGIS for Excel as soon as the user enters the address in the sheet. I can certainly use the ARCGIS.GETCOORDINATES function to geocode (lat, long numeric) in the sheet as columns of numeric values, but it does nothing to add this point to the map. How can I automate the sheet so that a point appears as soon as a user finishes entering an address in a column in Excel?

Re: Geocode points to map using address as soon as address is entered into excel

ShannonCardoza82 — Wed, 16 Nov 2022 20:00:47 GMT

Good afternoon Michael!

Thank you for the question. At this time, the option to automate the sheet so that a point appears after entering an address is not available.

The ARCGIS.GETCOORDINATES function can be used to calculate information, but should not be confused with automation which sounds a bit like what you are describing.

Hopefully, this helps. Please feel free to comment back with any further questions.

-Shannon