Re: What is the formula to change line properties from custom prop

Thank you for responding.
I am working with the shape*** for the object. When I tried to enter the
name "Prop.Message_Exchange_Method.Format" as a Shape Data property I
recieved an error. The error implied a decimal was not allowed in the
property name. I changed the name to "Prop.Message_Exchange_Method_Format"
and updated the Lookup formula.

However, the value returned for User.MsgExchMeth does not change. It
returns a -1.

any thoughts on what I did incorrectly?




"John" wrote:

Hi Anderson,

Have a go with the following (which uses an extra User cell):

Prop.Message_Exchange_Method.Format cell = "Manual; Automatic; Unknown"

User.MsgExchMeth cell
=LOOKUP(Prop.Message_Exchange_Method,Prop.Message_Exchange_Method.Format)

Line format cell =IF(User.MsgExchMeth=0,23,1)

The Lookup function returns the index of of the selected item (zero based),
so Manual=0, Automatic=1 and Unknown=2.

Let me know how you get on.

Best regards

John


"Anderson" <Anderson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1385A085-4E4D-4690-B51D-B4AF824448F8@xxxxxxxxxxxxxxxx
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?




.