Simple change of color on action menu not working

Started by John Distai, May 24, 2013, 06:21:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

John Distai

Hi.  I'm trying to create a simple shape that changes color based on a menu selection.  I'm using the code from Wapperdude's Microphone shape uploaded a while back as a base.

For some odd reason, when I change the menu value (enabled / disabled), I can see that my RGB variables change appropriately.  However, I can't get these numbers to update and make a change in the shape.

I'm thinking it has to do with this line of code:

=AND(User.ScrnRed=0,User.ScrnGrn=0,User.ScrnBlu=0)

In the Microphone example, Wapperdude has a sheet reference.  The code would look like this:

=AND(Sheet.5!User.ScrnRed=0,Sheet.5!User.ScrnGrn=0,Sheet.5!User.ScrnBlu=0)

I try to enter the "Sheet.ID!" reference before the User.Scrnxxx part, and Visio just clears it away.  I receive no error message.  The Sheet.x! just disappears.

Any idea what's going on?  I'm using 2010 Pro.

Thanks!

John Distai

Nevermind.  I found a User.FillClr example and that fixed it.