Reference data from shapes on another page

Started by alan, June 16, 2009, 07:40:46 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

alan

HI all, I am new to visio and am trying to display data (Text) from a shape on another page and display it as text.
Can anyone help ???

Visio Guy

Hi Alan,

You can insert a custom formula into one shape's text, to show the text on another page.

If you have two pages, with a shape on "Page-2" that has an ID of 1, then a shape on another page can refer to that shape's text if you do this:

1. Select your shape and go to: Insert > Field > Custom Formula
2. Type: = ShapeText( Pages[Page-2]!Sheet.1!TheText )

To find out about getting Shape IDs, check out this article:

  Top 9 Reasons for Turning-on Developer Mode

You'll want to specifically look at item "#8 Get Shape Names and IDs"
For articles, tips and free content, see the Visio Guy Website at http://www.visguy.com
Get my Visio Book! Using Microsoft Visio 2010

alan


markshultz

I am wondering if you can expand the answer to illustrate how to reference a shape attribute on another page.

E.g. to keep the position of a shape synchronized across pages, I would like to set the position coordinates (pinX, pinY) of a shape on Page-2 to the same coordinates as a shape on Page-1 pinX/pinY.

Paul Herber

Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/