Launch a sub in MapPoint in Excel

N

Nilses

Hello,

I have insert a map of USA in Excel (MapPoint in Excel) in
a worksheet in Excel. I have insert the name of each state
in this map. If i select a state, i have the name of this
state. I would like to launch a sub when i click on a
state like if i select Arizona, i have Sub Arizona_Click
but it's not possible but do you have a solution ?.

Thanks for your help

Nilses
 
S

steveb

Nilses,

If I insert an object onto my spreadsheet - right click on the object and
select 'Assign Macro'.

Worked fine with an inserted clip art. Might work with your map if each
state is a separate object (or the name is an object).
 
E

Eric Frost - MP2Kmag

I have insert a map of USA in Excel (MapPoint in Excel) in
a worksheet in Excel. I have insert the name of each state
in this map. If i select a state, i have the name of this
state. I would like to launch a sub when i click on a
state like if i select Arizona, i have Sub Arizona_Click
but it's not possible but do you have a solution ?.
Click to expand...

MapPoint is fully programmable from within an Excel macro/VBA
code. There are several example on MP2Kmag, this is probably
the most basic example:
http://www.mp2kmag.com/a39--word.access.excel.mappoint.html

You might find a number of other examples by searching like
this:
http://www.google.com/search?q=site:mp2kmag.com+Excel+VBA

best,
Eric

http://www.mp2kmag.com/mappoint.2004/guide
 
Top