PC Review


Reply
Thread Tools Rate Thread

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

 
 
TerryTee
Guest
Posts: n/a
 
      14th Dec 2009
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/comm...el.programming
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can I no longer change Font colors in an Excel 2007 Comment? Jaws68 Microsoft Excel Misc 1 28th Feb 2010 03:59 PM
Center text in a shape textframe DaveL Microsoft Excel Programming 4 19th May 2008 04:50 PM
How to retrieve text from the textframe of an oval shape in Excel? Greg M Microsoft Excel Programming 2 18th Dec 2007 03:10 PM
Change the Shape of a Comment in Excel 2007 Tanya Microsoft Excel Discussion 3 8th Feb 2007 11:42 PM
TextFrame.Characters.Text problem with grouped shape in XP pH7 Microsoft Excel Programming 4 26th Mar 2004 09:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:46 PM.