The information in this article applies to:
SYMPTOMSIn Microsoft Excel 97, when you select a color from the color palette, the value of the Microsoft Visual Basic for Applications ColorIndex property of the color you select may not be what you expect. CAUSEThis occurs in Microsoft Excel 97, because colors within the color palette are sorted chromatically, not by color index. This behavior is different than in earlier versions of Microsoft Excel. STATUSThis behavior is by design of Microsoft Excel 97. MORE INFORMATION
In Microsoft Excel, you can view the color palette by clicking the drop-
down arrow just to the right of the Font Color button on the Formatting
toolbar.
Q149170 XL: Sample Visual Basic Code to Create Color Index Table REFERENCES
For more information about the ColorIndex property, click the Office
Assistant while in the Visual Basic Editor, type ColorIndex click
Search, and then click to view "ColorInex Property."
Q176476 OFF: Office Assistant Not Answering Visual Basic Questions Additional query words: XL97 indexes indices
Keywords : kbui |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |