Propagating info

[Loretta]

I’m working on a drawing, in Visio 2003, where a user is supposed to be able to edit the Custom Properties of a specific shape, and have the text and color of some of the other shapes change based on the values entered. I’m having trouble getting the text and color to propagate correctly.

I have a shape called “MOlabel†that has the custom property “System†(among others) which gives the user a fixed list of systems to choose from. The Custom Properties section of the MOlabel shapesheet has the following values for the row labeled Prop.System:

Label = “Your systemâ€
Type = 1
Format = “Car;Truck;Planeâ€
(In real life, there are a whole lot more values for System, but I’m trying to simplify things)

I have another shape called “Spine†that has the following values in its User-defined cells section:

User.Color1 Value = “RGB(204,255,204)
User.Color2 Value = “RGB(204,255,255)
User.Color3 Value = “RGB(200,191,255)

When the user selects a MOlabel!Prop.System value of “Car†I want the text of Spine to be “small†and the color to be User.Color1
When the user selects a MOlabel!Prop.System value of “Truck†I want the text of Spine to be “medium†and the color to be User.Color2
When the user selects a MOlabel!Prop.System value of “Plane†I want the text of Spine to be “large†and the color to be User.Color3

I tried to set Spine’s FillForegnd using the SWITCH function (even though it gets VERY unwieldy with large numbers of choices), but it keeps telling me I have an error in the formula. This is what I tried to use:

=SWITCH(MOlabel!prop.System=“Carâ€, User.Color1, MOlabel!prop.System=“Truckâ€, User.Color2, MOlabel!prop.System=“Planeâ€, User.Color3)

Any suggestions of how to better do what I want?

I haven’t yet investigated the text part yet, but would appreciate any help on this also.