Dropdown to import in embedded Mappoint, need to refer to cell

[jake.masters]

Hi everyone,

I am trying to get a dropdown list of locations in excel to snap to the location in an embedded MapPoint map.

Does anyone know the VBA to zoom to location in Mappoint, or how to integrate these?

Sub Location()
    Dim oMap As MapPoint.Map
    Dim oLoc As MapPoint.Location
    Dim strPlace As String
    Set oMap = GetObject(, "MapPoint.Application").ActiveMap
    oMap.Application.Units = geoMiles

    Set oLoc = oMap.GetLocation(strPlace)
    oLoc.GoTo
End Sub

I need a way to tell VBA in MapPoint to look in a certain cell for the string value (Sheet main, cell E2), but the map is embedded in excel itself. Does anyone know how to refer to this location if it is embedded, or if this is even the correct way to do this? This cell will return a geoLocation for the drop down menu, which has city names.

Thanks!

[Rasheed_Pro]

sounds like quit difficult .. but the point is looking for map point right ..So u can calculate and put a picture on u r map on Graph and make a point while u choose a cell.. I have done this map .. I used that .. it was working great ..!