Solved

Referencing visSectionProp cell via row and column within a shapesheet cell

Posted on 2013-12-02
1
557 Views
Last Modified: 2013-12-02
Within the same shapesheet cell,
I can reference the visSectionProp Label cell in row: rowName as follows:
   prop.rowName.Label  or   by prop.rowName.2  (where the column value of Prop.Value = 0, Prop.Prompt=1, Prop.Label=2, etc)

As a result of automation, I want col.value to be chosen conditionally within the shapesheet.

So I want to set:  user.Col = 2 (for example)
... and then concatenate    prop.rowName.   AND   user.Col   to mean:  prop.rowName.2    

I got as far as EVALCELL(User.Colour) to yield the value 2, but..how do I joint that to prop.rowName. to yield prop.rowName.2, all within a shapesheet cell?

 Approx equivalent of Visio.Shape.CellsSRC(... ) in VBA.

Thanks,
Kelvin4
0
Comment
Question by:Kelvin4
1 Comment
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
Comment Utility
If the number of choices is relatively small, can you use something like
   ...IF(User.col=1, prop.rowName.Prompt, prop.rowName.Label)...
instead?
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
Book Review: Using Microsoft Visio 2010 by Chris Roth   Disclaimer: The author of Using Visio 2010 is a friend and fellow Visio MVP. Whether you’re new to Visio or are upgrading to Visio 2010 from a previous version, you will find a lot to like…
This video discusses moving either the default database or any database to a new volume.
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: …

743 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

17 Experts available now in Live!

Get 1:1 Help Now