News:

Happy New Year!

Main Menu

How to populate shapes with text from other shape?

Started by plstanisma, January 25, 2013, 09:41:55 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

plstanisma

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.



Surrogate

Please try use formula
=shapetext(sheet.17!TheText)

plstanisma

#2
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.

Surrogate

not at all, try this way  8)
=SHAPETEXT(Pages[Page-3]!Sheet.1!TheText)

plstanisma

YES! :) worked perfectly.. you saved me hours of work! thanks!

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: 210 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1056KB.
Tokens: post-login.
Cache hits: 13: 0.00150s for 26,548 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]