Check if a control point is glued to another shape

Started by Yacine, September 22, 2013, 06:23:31 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Yacine

Hi guys,
I wonder if it is possible to check by means of shapesheet functions if a control point is glued to a point in another shape.
In VBA it would be easy to read out the formula and check if it begins with "LOC(PNT(", but I'd rather like to avoid passing by a macro.

The left function gives back the numeric value in the control's coordinate field. Did not find any "formula" function.

Thanks in advance for your thougths,
Yacine
Yacine

wapperdude

In V2007, you get similar formula to what you show for the x- and y- cells.  For example, in the X cell for a glued control point, this formula occurs:  =LOC(PNT(Sheet.5!Connections.X1,Sheet.5!Connections.Y1)).  Otherwise, it's just some generic multiple of "width".  Sheet.5 was the shape to which the control point was glued.

HTH
Wapperdude
Visio 2019 Pro