Solved

Displaying/Hiding One Object Based Upon The Data In Another

Posted on 2007-11-23
4
240 Views
Last Modified: 2008-02-01
In Visio, one can define custom data fields on an object.

Let's say that I have two objects:  Object_A and Object_B.  Object_A has a user-defined variable: Var1.

If Object_A.Var1 = 0 then don't show Object_B.  Otherwise, show it.  

The actual showing/hiding can be accomplished via the object's transparency setting, but I don't know how to have one reference the other outside of writing a macro.
0
Comment
Question by:bmclaugh
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 20377193
You can do this in the shapesheets for the two objects and there's a better way than messing with transparency.

Item 1: In the shapesheet, look for the section called Geometry1. The first row includes a field called Geometry1.NoShow. If the value in this cell is FALSE, the shape appears; if TRUE, the shape doesn't appear on the page.

Item 2: You can refer to another object on the page using its name and an exclamation point (!). Consequently, "Prop.Var1" refers to the shape data field called "Var1" in the current shape, but "Object_B!Prop.Var1" refers to the field called "Var1" in the shape called "Object_B".

Combining Item 1 and 2:

In the shape sheet for Object_B, put the following formula into Geometry1.NoShow:
     =IF(Object_A!Prop.Var1=0,TRUE,FALSE)

Stated in English: If Var1 in Object_A = 0, NoShow in Object_B is set to TRUE and Object_B is invisible; if it's any other value, NoShow is FALSE and Object_B is visible.
0
 
LVL 30

Expert Comment

by:Scott Helmers
ID: 20503054
Did my previous answer solve your problem? If so, I would appreciate it if you would accept the answer and award the points. If not, let me know what additional information you need (for example, if you're not familiar with the Visio shapesheet, or need help getting the formula to work).

Thanks,
Scott
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20658526
Forced accept.

Computer101
EE Admin
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Scott A. Helmers Partner, Harvard Computing Group Microsoft Visio MVP Background Microsoft has added more enhancements and new features to Visio 2010 than to any release since they purchased the Visio product line in 2000. In addition, the com…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

708 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

11 Experts available now in Live!

Get 1:1 Help Now