News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

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/

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 225 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1107KB.
Tokens: post-login.
Cache hits: 13: 0.00189s for 26,742 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]