Setting child text value to custom property on parent in grouped s

[uk_dave]

Have a shape that is comprised of a group of two shapes, a text field and an
image. On the parent shape I have a custom property field with “Ask on dropâ€
toggled on. Is it possible to set the value of the child text field to be
the entered value of the parent custom property field? If so, how do I do
this? TIA

 

[Chris Roth [MVP]]

Hi UKD,

You need enter a more complicated formula in the Insert > Field dialog --
the sub-shape's text needs to do a "cross-sheet refernence" to get to the
group's prop-value. Try this:

1. Get the group's SheetID by selecting the group, choosing Format >
Special, and noting the ID. The group can now be referenced by "Sheet.ID".
So if ID = 5, then you use Sheet.5.
2. Select your sub-shape
3. Hit F2 to enter the text
4. Choose Insert > Field
5. Select "Custom Formula"
6. Enter this formula: Sheet.5!Prop.MyCustomProperty

Of course, MyCustomProperty is replaced by the name of the property in the
group that you want to reference, and .5 is the real id of you group.

That should get you going!

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/