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 2 of 2

MapPoint Control VBA help

This is a discussion on MapPoint Control VBA help within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi to all, I was hoping that someone on here may be able to help me with the VBA code ...

  1. #1
    arrancollins is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    7

    MapPoint Control VBA help

    Hi to all, I was hoping that someone on here may be able to help me with the VBA code to be able to do the following as I am struggling with it.

    I have a spreadsheet (also see attached) as follows:

    Column A B C D E F
    Title Name Address City County Post Code Include

    (Just so that you are aware, I am working in MapPoint Europe not MapPoint North America.)

    In my spreadsheet there will be anything from 10 to 1000 addresses detailed in columns B-E (in attached I have only included 3). In Column F I have a “Tick Box” that is linked to the same cell that it is contained within.

    What I would like to happen “Tick” the box of those addresses that I want to be included on the map, then click a button (Map Opportunities) that will then plot all of the “Ticked” addresses in to MapPointControl (named MappointControl1 embedded in a userform1)) as a PushPin and have the information in Column A (Name) in a balloon attached to the pushpin.

    If this is possible and if you can help with any of this it will be greatly appreciated.

    Thank you in advance.

    Regards

    Arran
    Attached Files Attached Files

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: MapPoint Control VBA help

    Hi,

    Here is a little procedure in C# that plot the pushpin. You have to translate it into VBA. I don't know how to get the information from the sheet.

    Code:
    private void plotPushPin(string Name, string Address, string City, GeoCountry Country, string PostCode)
    {
    	FindResults addrResults = MP.ActiveMap.FindAddressResults(Address, City, "", "", PostCode, Country);
    	Location loc = null;
    	foreach (object o in addrResults) {
    		loc = o as Location;
    		if (loc == null)
    			continue;
    		Pushpin pp = MP.ActiveMap.AddPushpin(loc, Name);
    		pp.BalloonState = GeoBalloonState.geoDisplayName;
    		break;
    	}
    	if (loc == null)
    		MessageBox.Show("Coordinates for " + Name + " not found");
    }

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 11-11-2009, 04:51 AM
  2. WPF and Mappoint Control
    By CSystem in forum Development
    Replies: 1
    Last Post: 06-05-2008, 04:25 AM
  3. Re: Keyboard control in mappoint activex control
    By djcapslock in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-10-2005, 11:16 AM
  4. Using MapPoint Control for Web App
    By Attila in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-11-2005, 10:36 AM
  5. MapPoint Control in ASP
    By technohippie in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-22-2004, 05:25 PM

Tags for this Thread

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 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127