I have made an excel XP spreadsheet containing 8 columns including 2 named latitude and longitude and a mappoint map. If I enter another row of data into the spreadsheet, double click the mappoint map and press shift and F9, the map refreshes itself.

Question is how can I write a macro so that when a row is completed and the cursor moves to the next row (lost focus?) I would like the map to automatically refresh. The 'record a macro' stopped recording when I double clicked on the map.

Any ideas on what the mappoint 'object' on my spreadsheet is called so I can name it in 'object'.updatelink?

Many thanks.