MapForums

arrancollins · #1 (**permalink**) 02-02-2010

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

**Wilfried** · #2 (**permalink**) 02-08-2010

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 Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
bingmaps: Bing Maps Silverlight Control developer video.... @ChrisPendleton dives into the control http://bit.ly/4g9w96	Bing Maps	Bing Maps Blogs & Tweets	0	11-11-2009 03:51 AM
WPF and Mappoint Control	CSystem	Development	1	06-05-2008 03:25 AM
Re: Keyboard control in mappoint activex control	djcapslock	MapPoint Desktop Discussion	1	03-10-2005 10:16 AM
Using MapPoint Control for Web App	Attila	MapPoint Desktop Discussion	1	01-11-2005 09:36 AM
MapPoint Control in ASP	technohippie	MapPoint Desktop Discussion	2	11-22-2004 04:25 PM

MapForums

MapPoint Control VBA help

MapPoint Control VBA help

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads