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

Accessing a shapes main text value?

Started by DaveTas, April 22, 2021, 03:49:47 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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

#1
Quote from: DaveTas on April 22, 2021, 03:49:47 AM
Sheet!X.TheText doesn't return what you can see on the screen..   
Try wrap this formula with SHAPETEXT function like this
SHAPETEXT(Sheet!X.TheText)

wapperdude

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

Surrogate

Quote from: wapperdude on April 22, 2021, 01:41:15 PM
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.
Visio 2019 Pro

Paul Herber

Is some equivalent of the Shapetext function available from VBA?
Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

wapperdude

Visio 2019 Pro

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: 296 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1152KB.
Tokens: post-login.
Cache hits: 13: 0.00181s for 26,725 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]