Improve company productivity with a Business Account.Sign Up

x
?
Solved

Expressing shapesheet user.values within text entered in the ShapeSheet Comments cell

Posted on 2013-11-16
3
Medium Priority
?
683 Views
Last Modified: 2013-11-17
Hi
I have a visio shape which contains two shapesheet user variables:

User.apples (value = 4)
User.pears   (value = 3)

I want the comment cell in the shape /miscellaneous section to concatenate these values into text, so that when the mouse is run over the shape, the comment box reads:
"I have 4 apples and 3 pears."

"I have " & User.apples & " apples and " & User.pears & " pears."  does not evaluate the shapesheet references.

Can I do this without using vba to 'hard write' the comment text I need?

Kelvin
0
Comment
Question by:Kelvin4
  • 2
3 Comments
 
LVL 31

Expert Comment

by:Scott Helmers
ID: 39654256
You're heading in exactly the right direction... must just be punctuation. I think this is what you want:
shapesheet.PNG
0
 
LVL 31

Accepted Solution

by:
Scott Helmers earned 2000 total points
ID: 39654259
one more thought -- be sure you have a equal sign at the beginning of the formula
0
 

Author Closing Comment

by:Kelvin4
ID: 39655006
Thanks! (It would have helped if I'd read my shapesheet cell for VALUE, not Formula!
Hiho..)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Periodically someone asks me whether there’s a way to automatically convert all of the pages in a Visio drawing to PowerPoint slides. There have even been a few times when I’ve wanted to do that myself but I never really had enough incentive to figu…
The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine containers. We’ll explore lists (http://www.experts-exchange.com/Microsoft/Applications/M…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
Watch the software video of Kernel Import PST to Office 365 tools which can easily import PST and OST files to Office 365 for bulk mailboxes. The process of migration is simple and user can map source and destination mailboxes and easily import data…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question