Get RGB color ?

S

SpookiePower

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 ?
 
T

Tom Ogilvy

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

? activecell.Interior.Color
 
C

chijanzen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top