If you want to see a color chart, open the Visual Basic Editor and click
Help. Type in the search box "PatternColorIndex Property" without the quote
marks and then click on the same words when they show in the options panel.
This will display the chart with the numbers for the colors. If you print
the chart you will notice that your printer limits the amount of variation to
the colors based on the printer capabilities so that when printed, index
numbers 18, 29 and 54 might look the same when printed.

"Jaylin" wrote:

I have the following code with colorindx number 1 representing black color,

May I know how do I get the related color constatn list (ie what number =
what color) in VBA

With Selection.Interior
.ColorIndex = 1
End With

--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******