Guide to colour numbers

[SharpL]

Hi,

I'm currently setting up some keyboard shortcuts via Macro to colour cells.

Is there a guide to which what colours are what number for coding? For example:

 .Color = 65535

Thanks in advance

[Speshul]

This might help:


http://www.endprod.com/colors/


(The 'MSAccess' column is the same index as Excel .color property)

[Speshul]

Or, a fun alternative,

Run this

Not sure how to sort it properly, I guess the color codes aren't particularly sequential by color

Sub Macro1()
Application.ScreenUpdating = 0

For i = 1 To 100000000 Step 200000

Range("a1").Offset(y, 0).Select
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = i - 1
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    Range("B1").Offset(y, 0).Value = i - 1
    y = y + 1
    
Next i
Application.ScreenUpdating = 1

End Sub

[SharpL]

Thank you

[romperstomper]

FYI, they are RGB values ranging from RGB(0,0,0) to RGB(255,255,255) - i.e. 0 to 16,777,215.