color index

[marina madeleine]

Does anyone know how I can find the color numbers in VB Excel for the
color index. For example, for the color aqua?

Thanks.

Marina Madeleine


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[madbloke]

Have a look 'here.
(http://www.personal-computer-tutor.com/abc2/v18/chad18.htm) . Th
article is about conditional formatting, but there's a colour chart o
there. Hope that helps.

 

[anne]

Hi Marina,
you can find the color index in the visual basic help.
Enter "colorindex" and you get the description for the use
of the available numbers. For aqua it might be number 50.

Anne

 

[Mark]

See, "ColorIndex Property" in VBA help.
Aqua (sea) have ColorIndex = 8

HTH
Mark

 

[David McRitchie]

Actually this is the page that is being maintained.
http://www.mvps.org/dmcritchie/excel/colors.htm
the page on geocities is not being updated. It is the
56 ColorIndex numbers that are important in Excel.