Using a Fixed List in Custom Properties

[MikeM]

I put a variable Prop.Sex in Custom Properties, with ="M;F". In trying to use
the property, I'm getting nowhere. I want to change the line color of the
shape with this property, so I enter, for line color,

=if(Prop.Sex="M",3,4) -- or whatever colors I choose.

However, when I change the sex, the line color doesn't change.

 

[Chris Roth [MVP]]

String comparisons in Visio's ShapeSheet are not obvious, and you can't just
use "=". Don't feel bad about missing this, it's black-magic-obscurity.

You need to use the StrSame function, i.e.: If(StrSame(Prop.Sex, "M"), true,
false)

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

 

[MikeM]

Thanks, Chris. Solved the problem!!

Mike

String comparisons in Visio's ShapeSheet are not obvious, and you can't just
use "=". Don't feel bad about missing this, it's black-magic-obscurity.

You need to use the StrSame function, i.e.: If(StrSame(Prop.Sex, "M"), true,
false)

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/