A
Anderson
I am using the Visio 2007 Pro edition:
I would like to change the Line Pattern for an object based on the contents
of a custom properties cell.
I created a custom Shape Data property call "Message_Exchange_Method". It
has three values (Manual, Automatic, Unknown) and I want to change the line
pattern based on the value.
The closest function I could find was the "IF" function even though it
doesn't really have an ifelse type option.
When I tried using the "IF" statement, it would always evaluate to "true".
IF((Prop.Message_Exchange_Method)="Manual",23,1)
I saw the thread in this group named: IF()Functions and strings and then
tried the following:
STRSAME(Prop.Message_Exchange_Method,"Manual",23). But this did not
evaluate as expected and limits the values that may be listed in the cell
contents for Message_Exchange_Method.
I have successfully used functions to get cell contents with "Text Field" (
=(Prop.ICD_No)&CHAR(10)&(Prop.DataType1)&CHAR(10)&(Prop.DataType2) )
Do you have any suggestions for how I can make the line pattern change based
on contents of another cell?
I would like to change the Line Pattern for an object based on the contents
of a custom properties cell.
I created a custom Shape Data property call "Message_Exchange_Method". It
has three values (Manual, Automatic, Unknown) and I want to change the line
pattern based on the value.
The closest function I could find was the "IF" function even though it
doesn't really have an ifelse type option.
When I tried using the "IF" statement, it would always evaluate to "true".
IF((Prop.Message_Exchange_Method)="Manual",23,1)
I saw the thread in this group named: IF()Functions and strings and then
tried the following:
STRSAME(Prop.Message_Exchange_Method,"Manual",23). But this did not
evaluate as expected and limits the values that may be listed in the cell
contents for Message_Exchange_Method.
I have successfully used functions to get cell contents with "Text Field" (
=(Prop.ICD_No)&CHAR(10)&(Prop.DataType1)&CHAR(10)&(Prop.DataType2) )
Do you have any suggestions for how I can make the line pattern change based
on contents of another cell?