Accessing a shapes main text value?

[DaveTas]

I am quite used to shapesheets and adding text fields to existing subshapes etc.

But I need to access a shapes main text value without adding a new field...  ie If I want to refer to the main shapes text from within a subshape..

Sheet!X.TheText doesn't return what you can see on the screen..   

NOTE: this shape is already linked to a database so I cannot change the object that houses the text.  It is just the standard text block for the shape, but the value doesn't appear in the shapesheet at all...

[Surrogate]

Sheet!X.TheText doesn't return what you can see on the screen..   

Try wrap this formula with SHAPETEXT function like this

Code Select Expand

SHAPETEXT(Sheet!X.TheText)

[wapperdude]

Shouldn't that be...Sheet.X!, not Sheet!X???

[Surrogate]

not Sheet!X???

Of course !The first time I saw this message on my phone, I didn't see the typo...

[wapperdude]

@ Surrogate:  I'm sure that's all it was, a typo.  Regardless, would still need the Shapetext wrapper as you indicated.

[Paul Herber]

Is some equivalent of the Shapetext function available from VBA?

[wapperdude]

The closest vba equivalent is Characters.  See the following.  The forum reference shows various syntax approaches.  The M$ links are more to the point.

Forum:
http://visguy.com/vgforum/index.php?topic=7638.msg32400#msg32400
http://visguy.com/vgforum/index.php?topic=9067.msg40123#msg40123
http://visguy.com/vgforum/index.php?topic=5678.msg40628#msg40628 => adding Field Text

From M$:
https://docs.microsoft.com/en-us/office/vba/api/visio.shape.characters
https://docs.microsoft.com/en-us/office/vba/api/visio.shape.text

[Paul Herber]

Ah yes, thanks.