This was prepared by request, it allows you to set up a list of lat/lon's in Excel and draw drive-time zones around each location. You can specify the color and number of minutes for each location.

Enjoy!

Eric

I created a new version of this for a MapForums Plus member who wanted to be able to specify an existing map and add the new drivetime zones on top of the existing map. If this would be useful to anybody let me know and I'll post the new version.

Could this marco be adjusted to provide the option to hide the drivetime size label? I saw that this option exists on the circle around a long/lat. The labels are hiding the drive zones in my application.

Thank you.

Hi Nolster!

Thanks for your patience.

I have added this as an option for each row, see attached.

Drivetimes_Around_LatLon_v2.zip

Just fill in "FALSE" for all the rows if you do not want the Size to show for any of the drivetime zones.

Eric

Drivetimes_Around_LatLon_v2.zip

Now that all of the drive time labels are hidden, I can see there is an issue with borders. This I fixed myself, just manually making the border color the same as the zone color inside the VB code. Works great at this point. Thank you for your help.

BTW - we are mapping nationwide, to show clients points of presence coverage against contracted drive time. Works incredible.

Eric

This looks like just what I need - I'm not a VBA expert, so it would be good to have some guidance on three points - any changes required for 2013 version, any changes required for Europe map and how could I make it use postcodes rather than lat long. Very many thanks in advance.


Kirsten

Do you mind to share 10 or so sample postcodes? I will prepare a new tool that works with postcodes and test to make sure it works properly with MP13EU.

Eric

Eric

Thanks for this - here are some sample postcodes:

G31 4EB

LS11 5BJ

CV3 4AR

OX4 3JP

TQ2 7AN

TR10 9LY

NR6 5DT

CT11 7PR

E10 5NH

RG30 4EL

Kirsten

Sorry - should have looked at preview first - these should read, for example, G31 4EB.

I took a quick stab at this, see attached.

This doesn't have all the bells & whistles of some similar tools I did recently e.g. all the options in this tool -- Draw Circles from Addresses v3.0 but let me know if you want them and I can certainly add them for you.

Eric