Bug in Comment.Shape.TextFrame.Characters.Font.Color in Excel 2007

[TerryTee]

Hi.
I’ve found what seems to be a bug in the
Comment.Shape.TextFrame.Characters.Font.Color. The ColorIndex works fine, but
not the .Color. When setting the .Color with RGB() the result is simply
wrong. There might be a pattern but I have not researched enough to find one.
A simple test to confirm the bug is to set the Color and then read it back.

Examples:
Comment.Shape.TextFrame.Characters.Font.Color=RGB(1,0,0) ‘becomes
RGB(0,255,255)
Comment.Shape.TextFrame.Characters.Font.Color=RGB(65,0,0) ‘becomes
RGB(128,128,128)
Comment.Shape.TextFrame.Characters.Font.Color=RGB(192,0,0) ‘becomes
RGB(0,128,0)

Regards,
-Terry


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a4a2426&dg=microsoft.public.excel.programming