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

MichaelBishopp

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?

ShannonCardoza82

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