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

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).

--
steveb
(Remove 'NOSPAM' from email address if replying direct)
"Nilses" wrote in message
...
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

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 ?.

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.acc....mappoint.html

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

best,
Eric

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