VBA Call from 2D Shape

[metuemre]

Hi all,

I'm trying to call a VBA macro from a 2D shape if a connector is connected to or disconnected from one of the connection points of the 2D shape but I couldnt find a cell in the 2D shape that changes its value with this connect/disconnect process. Incoming or outgoing connectors have BegTrigger and EndTrigger cells that changes but I need a cell in the 2D shape.

Do you know a way to accomplish this?

Regards
Emre

[Yacine]

Hi Emre,
A solution for this problem would indeed by nice, but I only know of solutions based on both connectors and 2D shapes.
Here's a thread, in which you were involved and which demonstrates Junichi's solution: http://visguy.com/vgforum/index.php?topic=8542.0
Cheers,
Y.

[metuemre]

Hi Yacine,

It would be nice to handle it in 2D shape directly, thanks anyway.

Regards,
Emre

[vojo]

if doing VBA, why not other way around:  Make a small list or DB.  when connector placed, it updates list with
connector name, srce, dest.   Then if something of 2D, query the list or DB to see if connected.