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

T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom color in Excel 2007? 1
How to get Excel to use a custom RGB color in a chart series? 5
RGB for column and row headers colors in Excel 2007 4
Bug Report: VBA runtime Access Violation 1
Excel 2007 conditional formatting - how to get cell color? 3
Erroneous Macro Recording 0
C application connected to Excel 4
Conditional Formatting in Excel 2003 0

Top