This tool is very similar to the Drawing Drivetimes Zones worksheet in the MapPoint Power Tools Spreadsheet.

Basically instead of specifying minutes for the drivetime, you specify miles for the radii or circles to be displayed. Again it takes another column for the color.

See attached screenshot to get an idea of the operation.

Let me know if you have any problems, I would also be happy to prepare a European version if requested.

It will be published the code in an upcoming MP2Kmag newsletter. Subscribe here --
http://www.mp2kmag.com/update/

Eric

By the way, if you are working with shapes in MapPoint, you will probably be interested in MPSuperShape from Mapping-Tools.com -

MPSuperShape: Home Page

There is a 14-day, fully functional free trial --
MPSuperShape: Downloads

MapForums Plus subscribers can get a 10% discount when using the Plimus checkout option --
10% Discount on Mapping-Tools Products!
You must choose Plimus as the payment processor to receive the 10% discount.

Eric

Hello Eric..

Could u make a Euro version with km as standard?

René.

Sure, I'll do that right now.

Eric

I don't have the European version installed on this computer so I haven't tested it, but see attached, it might work.

If anything, I think you may just need to change the reference in the VBA Editor. Go to Tools | References and then go down and check the box next to "Microsoft MapPoint 16.0 Object Library (European)".

If you can't get it to work, I'll be at a computer with the European version on Monday and can test it and make sure it's working then.

Eric

Hello Eric..

It works , but theres a few bugs..

It seems to show adress-hit for the whole country not just the designated zipcode.

Im denmark we use a 4 digit zipcode, and dont use "states", and when I set the radius to 0,6 km, it displays as 0,300 km in mappoint..

Ill be happy to send u my database if u need some to work with.

René

Yes, please send a sample with some EU addresses

Either attach here or send to website AT(@) mp2kmag dot com

Eric

Here's the new one for EU with some sample addresses in Denmark.

Eric

Here's a similar tool but uses a list of Lat/Lon's instead of address.

Drawing Circles Around a List of Lat/Lons

Eric

Hey Eric..

Ty for the sheets.. they have been a big help in my work so far..
About ur new Lat/Lon sheet.. can u incorperate it with the normal adress sheet?
So u can opt for typing the adress or Lat/Lon?, and most importantly, it displays both the typed adresses and Lat/Lon locations..

Regards
René.