Shape Property based on connected shape?

P

Philo

How can I set a property (Fill color) on a shape based on a property of a
connected shape? (along with a default value if that type shape isn’t
connected)

Thanks!

Philo
 
C

Chris Roth [ Visio MVP ]

It has to be done with code, can't be done purely with the ShapeSheet.

To change the fill color programmatically:

visShp.Cells("FillForegnd").ResultIU = 2 'makes a shape red, also,
..Formula

To determine if a shape has connectors attached, check the
shp.FromConnects.Count. Remember that Control handles and Guides might also
be glue to the shape, so there are more things to check...

--

Hope this helps,

Chris Roth
Visio MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top