Visio Guy

Visio Discussions => Shapes & Templates => Topic started by: bernd on June 02, 2016, 02:22:37 PM

Title: Editing a line shape
Post by: bernd on June 02, 2016, 02:22:37 PM
Dear all,
I try my first steps in Visio (2010) programming and need some support..
I declared some props behind a line mastershape. One prop is named "Funktionsart". Depending on the value behind this prop the style of the line should change..
The Code in the shapesheet.lineformat is:   
=IF(Prop.Funktionsart="Schädliche Funktion","4","1")
This works exaktly one time.. but not after changing the "Funktionsart" back to another value..

Perhaps it is simple? What is my mistake?

Thank you in advance for your support..
Kind regards, Bernd
Title: Re: Editing a line shape
Post by: Surrogate on June 02, 2016, 04:12:16 PM
Hi,

for compare strings use STRSAME function (https://msdn.microsoft.com/en-us/library/ms425572(v=office.12).aspx)
QuoteIF(strsame(Prop.Funktionsart,"Schädliche Funktion"),"4","1")
Title: Re: Editing a line shape
Post by: bernd on June 04, 2016, 10:57:08 AM
 :)  Works - Thank you very much !!