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

 

[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

 

[Peter T]

Hi Marina,

If you mean colour numbers 0 to 1677215 these can be
returned with a simple routine:

Sub CxToCvalue()
Dim i As Byte
For i = 1 To 56
Cells(i, 1).Interior.ColorIndex = i
Cells(i, 2) = i
Next
End Sub

There is no direct way to return any information about the
colour descriptions (eg Aqua) you see in the tooltips when
you hover over the palette. But you may find links in this
NG to code which includes "hardcoded" details relating to
the colour descriptions.

There are eight intuitively named "Color Constants", eg
MsgBox vbYellow, , vbRed

Also 0 to 15 colours with the "QBColor" function (does not
include Aqua!)

Regards,
Peter

 

[MoonWeazel]

Hi,

I found the following site invaluable when finding out th
RGB/Hex/names for colours!

http://www.geocities.com/davemcritchie/excel/colors.htm

Hope it helps you!!

Thanks,

MoonWeaze

 

[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.