With Excel 2003...

I'm using this line to set the text color (forecolor) of a checkbox:

Please Login or Register  to view this content.
I use a custom function to set the color of some chart entities to this same color:

Please Login or Register  to view this content.
The basic idea here is that the checkbox controls the display of a graph series, and the user can select the color for the series, which includes the checkbox text, series line color, and axis display. Everything works fine, except the checkbox ForeColor property doesn't always update to the correct color. In fact, it seems random and doesn't make any sense at all. It doesn't seem to matter if I update the colors in Deactivate on the "Preferences" page, Activate on the "Dyno" page, or anywhere else; sometimes the checkbox forecolor updates, and sometimes it doesn't. I have several checkboxes on two separate sheets that all show this same behavior.

I'm not loading other palettes or anything else, so I don't understand why it isn't updating to the correct color.

Any ideas?