Visio Guy

Visio Discussions => ShapeSheet & Smart Shapes => Topic started by: Scott10284 on April 10, 2024, 02:10:58 PM

Title: Change Text Color Through Shapesheet
Post by: Scott10284 on April 10, 2024, 02:10:58 PM
I have fixed list shape data at the outer most layer of the grouped shape (Shape 2459). One layer down I have text that I want to change to red when the "CHOOSE" selection is made at the fixed list. All other selections should result in black text.

Under the Character section, here is the code that I put in the Color field. The problem that I am having is that the result is always RED and I cannot see why?

=IF(sheet.2459!Prop.OUT1Config="CHOOSE",2,0)

Scott

Title: Re: Change Text Color Through Shapesheet
Post by: wapperdude on April 10, 2024, 02:41:54 PM
You're doing a string comparison.  Use strsame shapesheet fcn:  https://learn.microsoft.com/en-us/office/client-developer/visio/strsame-function (https://learn.microsoft.com/en-us/office/client-developer/visio/strsame-function)
Title: Re: Change Text Color Through Shapesheet
Post by: Scott10284 on April 10, 2024, 02:50:15 PM
Wapper, this worked perfectly. Thanks!!!!