Visio Guy

Visio Discussions => General Visio => Topic started by: plstanisma on January 25, 2013, 09:41:55 AM

Title: How to populate shapes with text from other shape?
Post by: plstanisma on January 25, 2013, 09:41:55 AM
Hello,
I am new to Visio. I am struggling with simple thing ( i couldn't find answer on google).

What i need to do is:
1. type text into one textbox/field (i.e. title box on title page)
2. i would like visio to populate header of other pages with this title. (see attachment)

I would like it to be very simple for the end user.

How can i achieve that?



I was trying to use field with custom formula :
1. Fieldpicture(0);=sheet.17!TheText on TextFields section of the shape in header.
2. i tried also a macro, but i cannot determine the event which will allow me to update the text in header after typing it on the first page.


Title: Re: How to populate shapes with text from other shape?
Post by: Surrogate on January 25, 2013, 10:17:11 AM
Please try use formula
=shapetext(sheet.17!TheText)
(http://www.xtwo.info//medium/CF.png)
Title: Re: How to populate shapes with text from other shape?
Post by: plstanisma on January 25, 2013, 10:30:13 AM
Thank you! Surrogate,

that helped a lot! it works for shapes which are located on the same page.

Hovewer it doesn't work when the other shape is on different page (in my case background page for every other page with text box as a header).

i tried on the background page shape :



=shapetext(TitlePage!sheet.17!TheText)

=shapetext(TitlePage.sheet.17!TheText)

=shapetext(TitlePage:sheet.17!TheText)


but it doesn't do the trick.

is there a way to use a reference to a shape on other Visio Page? I am thinking USER CELLS, but have no clue how to use it yet.
Title: Re: How to populate shapes with text from other shape?
Post by: Surrogate on January 25, 2013, 10:34:39 AM
not at all, try this way  8)
=SHAPETEXT(Pages[Page-3]!Sheet.1!TheText)
Title: Re: How to populate shapes with text from other shape?
Post by: plstanisma on January 25, 2013, 10:38:19 AM
YES! :) worked perfectly.. you saved me hours of work! thanks!
Browser ID: smf (is_webkit)
Templates: 1: Printpage (default).
Sub templates: 4: init, print_above, main, print_below.
Language files: 1: index+Modifications.english (default).
Style sheets: 0: .
Hooks called: 53 (show)
Files included: 25 - 925KB. (show)
Memory used: 763KB.
Tokens: post-login.
Cache hits: 7: 0.00109s for 22,302 bytes (show)
Cache misses: 1: (show)
Queries used: 9.

[Show Queries]