Author Topic: Check if a control point is glued to another shape  (Read 1557 times)

0 Members and 1 Guest are viewing this topic.

Yacine

  • Hero Member
  • *****
  • Posts: 2711
Check if a control point is glued to another shape
« on: September 22, 2013, 01:23:31 PM »
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
« Last Edit: September 22, 2013, 01:25:16 PM by Yacine »
Yacine

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3829
  • Ideas Visio-lized into solutions
Re: Check if a control point is glued to another shape
« Reply #1 on: September 22, 2013, 04:31:05 PM »
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