Get RGB color ?

I have found a color in the color palette that I will use to color some cells.
But how do I find the RGB numbers for the color so I can use it in VBA ?


--
Mit fotoalbum
www.photo.activewebsite.dk

It is one of the standard colors that i want the RGB numbers on

Color a cell manually and query the interior.color property.

? activecell.Interior.Color

--
Regards,
Tom Ogilvy

"SpookiePower" <boxjunk2600@gmail.com> wrote in message
news:43ca4adf$0$78283$157c6196@dreader1.cybercity.dk...
> It is one of the standard colors that i want the RGB numbers on
>
>

SpookiePower:

try, Get Activecell.Interior.Color

Dim R As Integer
Dim G As Integer
Dim B As Integer
Dim RGB As Long
RGB = ActiveCell.Interior.Color
R = RGB And 255
G = RGB \ 256 And 255
B = RGB \ 256 ^ 2 And 255
GetRGB = R & "," & G & "," & B
MsgBox GetRGB

--
天行健，君�*�以自強不息
地勢坤，君�*�以厚德載物

http://www.vba.com.tw/plog/


"SpookiePower" wrote:

> It is one of the standard colors that i want the RGB numbers on
>
>
>