Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 6 of 6

Draw Circles from Addresses v3.0

This is a discussion on Draw Circles from Addresses v3.0 within the MapForums Plus Downloads forums, part of the MapForums Plus category; The latest version of this popular tool adds columns/options for setting the Pushpin Name and controlling whether the shape appears ...

  1. #1
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Draw Circles from Addresses v3.0

    The latest version of this popular tool adds columns/options for setting the Pushpin Name and controlling whether the shape appears in front of or behind the roads.

    Download here -- Draw_Circles_from_Addresses_v3.0.xlsm.zip

    Full source code is included for subscribers to the MapForums Downloads section ($99/year).

    Previous versions of this tool and related tools can be found here --

    http://www.mapforums.com/draw-circle...ion-19053.html

    Drawing Drivetime Zones Around a List of Lat/Lon's

    Drawing Circles Around a List of Lat/Lons

    Drawing Radii (Circles)

    I'll just let the pictures explain this tool. First, put in your addresses and set the properties of the circles you want to create.



    Click Begin, and it will open MapPoint and generate your map!



    Potential future enhancements could include the ability to add circles to an existing map as opposed to always creating a new map.

    Another idea might be to have an option to set the relative order of the circles to control in what order the circles appear on the map relative to each other.

    Let me know if anyone wants these features or others added to this tool.

    Also, let me know what other tools or enhancements to existing tools you would like to see.

    Eric

    Draw_Circles_from_Addresses_v3.0.xlsm.zip
    Last edited by Eric Frost; 02-13-2013 at 11:39 AM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    Tim Finnigan is offline Junior Member White Belt
    Join Date
    Aug 2013
    Posts
    6

    Re: Draw Circles from Addresses v3.0

    Hello Eric-
    is there a tool to draw circles ( I need 25-50-100-200miles) around generic city names- not address,long lat?
    Thank You

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Draw Circles from Addresses v3.0

    I modified the macro to work with Place Names, see attached.

    Place Name is a single field, so if you have City and State is separate fields, those would need to be combined first. (My reasoning for doing this was that you can then also include other Geography Place names such as the example Statue of Liberty I threw on there).

    Please give this a whirl and let us know if it accomplishes what you needed!

    Draw_Circles_from_Place_Names_v3.0.xlsm.zip

    Eric
    Last edited by Eric Frost; 08-13-2013 at 10:36 PM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  4. #4
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Draw Circles from Addresses v3.0

    One user was having trouble using this.

    They have UK Postal Codes and Cities, and are using MapPoint 2013 Europe.

    The European version wasn't the issue, but the macro stops after it finds the first blank cell in the address column.

    This can be changed at this line of the code --

    Code:
      'test to see if there is address in column 2 (B) for the current row
      Do While Cells(nReadRow, 2) <> ""
    Just change it to
    Code:
      'test to see if there is a name in column 1 (A) for the current row
      Do While Cells(nReadRow, 1) <> ""
    Even better, it could check all the columns to make sure it's a blank row before it stops, something like --

    Code:
      'test to see if there is a blank row
      Do While Cells(nReadRow, 1) <> "" and Cells(nReadRow, 2) <> "" and Cells(nReadRow, 3) <> "" and Cells(nReadRow, 4) <> "" and Cells(nReadRow, 5) <> "" and Cells(nReadRow, 6) <> ""
    Let me know if you have any trouble with this macro and I'd be glad to help!

    Eric
    Last edited by Eric Frost; 09-16-2013 at 10:59 AM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  5. #5
    proudfoot is offline Junior Member White Belt
    Join Date
    Sep 2013
    Posts
    1

    Re: Draw Circles from Addresses v3.0

    This is a fantastic tool. Well worth the yearly fee to download it. Made my life so much easier.

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Draw Circles from Addresses v3.0

    Let me know if there's anything else you'd request to automate things in MapPoint.

    I know the tools in here are definitely not an exhaustive list of things that can be accomplished with MapPoint.

    Customers are always welcome to request/suggest tools and (or contract with us at a reasonable rate for custom development!)

    Erc
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Draw Circles from Addresses v2.0
    By Eric Frost in forum MapForums Plus Downloads
    Replies: 6
    Last Post: 02-04-2013, 02:06 PM
  2. Automatic radius circles?
    By tukes in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 06-02-2008, 10:33 AM
  3. Shaded Circles
    By dgermain in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-12-2007, 11:42 AM
  4. Map Point VBA - Plotting circles
    By Phil Holt in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 02-05-2006, 05:33 AM
  5. Circles
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 12-08-2003, 11:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101