Help!

Changing the text or the name of a shape based on a second..

 
  

Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Creating Shapes RSS
Next:  Visio timeline shapes - what do they mean?  
Author Message
Dirk Bernhard
External


Since: Jan 18, 2007
Posts: 1



PostPosted: Thu Jan 18, 2007 5:57 pm    Post subject: Changing the text or the name of a shape based on a second shape using shapesheets
Archived from groups: microsoft>public>visio>createshapes, others (more info?)

Hello,

I am a newbie for shapes and shapesheets.

I want know if it is possible to change the text from shape based on the
input of text in another shape.
e.g. Text of shape 1 is: "abc"
Then the name of Shape 2 should be "XYZ."+Shape1.text i.d. "XYZ.abc"


I know that e.g. the width can be changed on base on the width of a second
shape e.e width = Shape2!width

Where can I find the approriate function for the text. It should be include
either in an shapesheet or in a field function.

I would appreciate any help.


Thanx

Dirk
Back to top
Roger
External


Since: Apr 21, 2006
Posts: 25



PostPosted: Thu Jan 18, 2007 5:57 pm    Post subject: RE: Changing the text or the name of a shape based on a second shape u [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello Dirk

Using the Visio Insert>Field menu you can enter a custom formula along the
lines of:
="ABC"&SHAPETEXT(Sheet.1!TheText)&"XYZ"

Best regards
Roger Billsdon

"Dirk Bernhard" wrote:

> Hello,
>
> I am a newbie for shapes and shapesheets.
>
> I want know if it is possible to change the text from shape based on the
> input of text in another shape.
> e.g. Text of shape 1 is: "abc"
> Then the name of Shape 2 should be "XYZ."+Shape1.text i.d. "XYZ.abc"
>
>
> I know that e.g. the width can be changed on base on the width of a second
> shape e.e width = Shape2!width
>
> Where can I find the approriate function for the text. It should be include
> either in an shapesheet or in a field function.
>
> I would appreciate any help.
>
>
> Thanx
>
> Dirk
>
>
>
Back to top
vojo
External


Since: Aug 23, 2006
Posts: 34



PostPosted: Thu Jan 18, 2007 5:57 pm    Post subject: RE: Changing the text or the name of a shape based on a second shape u [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

if the 2 shapes are in the same group...its easy

in shape 1 have a user or prop cell with text (default "ABC")
in shape 2 have a user or prop cell with
if (samestr(shape1,"ABC"), "XYZ","PDQ")....extend as needed...127 chrs max
in shape 2 use insert field and insert cell user or prop cell (in shape 2).

If not in same group...much more problematic
(for instance drop shape 1 then shape 2...no relation made or managed).
would need VBA code to do

One of the hugely nagging limitations of visio is that without group shapes,
there is no nice way for shape affliation or discovery. Always got to use
VBA to do that if not grouped

"Dirk Bernhard" wrote:

> Hello,
>
> I am a newbie for shapes and shapesheets.
>
> I want know if it is possible to change the text from shape based on the
> input of text in another shape.
> e.g. Text of shape 1 is: "abc"
> Then the name of Shape 2 should be "XYZ."+Shape1.text i.d. "XYZ.abc"
>
>
> I know that e.g. the width can be changed on base on the width of a second
> shape e.e width = Shape2!width
>
> Where can I find the approriate function for the text. It should be include
> either in an shapesheet or in a field function.
>
> I would appreciate any help.
>
>
> Thanx
>
> Dirk
>
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Creating Shapes All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum