Solved

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

Posted on 2013-11-16
3
613 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 30

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 30

Accepted Solution

by:
Scott Helmers earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 lists. We’ll explore containers and callouts in separate articles. Prior to reading th…
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 I’ll describe a mashup of containers and lists that meet a real-world need. Prior to reading this ar…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

948 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now