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