Cells Color Properties

[shannondbaker]

Good Afternoon Board,

I want visual basic to assign an exact color to a cell but I don't know how to select more than the default colors allowed. I ultimately need to give it the command for RGB (red, green, blue) and possibly HSL (hue, saturation, luminance). Below, you will find code for a cell and a textbox. I want to be able to have as much control as the textbox code for the cell. I'm sure this is a minor overlook on my part, but your help would be appreciated.

Thanks in advanced,

Shannon

SAMPLE CODE (Textbox):

ActiveSheet.Shapes("Text Box 16").Select
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(51, 153, 255)

SAMPLE CODE(Cell):

With Selection.Interior
.ColorIndex = 30
End With

 

[Cbrine]

Activesheet.range("A1").interior.color for the RGB
Activesheet.range("A1").interior.colorindex for and indexed color.

 

[Juan Pablo González]

For cells you can only have 56 colors... you can try to use the RGB color to use a different one, one that is not defined in the 56 color palette, but then Excel will try to use the closest one to it.

 

[Wayne L.]

Juan, is it possible for VBA to modify the default palette? If so, would the modified palette be attached to the workbook, or the application?