Color in Visual Basic

[tcebob]

Here's an excerpt from a macro I recorded to try to dope out the color code:
.Color = 7260360
This is R=200,G=200,B=110
or Hex c8c86e
How can I translate from RGB or Hex to VB? (or back)

 

[Steve from Texas]

The RGB color code is [blue]*256*256 + [green]*256 + [red]
So, for yours 110*256*256 + 200*256 + 200 = 7260360

 

[Luck]

Try this
Sub Test()
Dim LR as long
LR= Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To LR
R = Cells(i, 1).Value
G = Cells(i, 2).Value
B = Cells(i, 3).Value
Cells(i, 4).Interior.Color =RGB(R,G,B)
Next i
End Sub