VBA RGB Colour Name

[Biz]

Dear All,

Is there VBA code which can give colour name based on RGB (232,241,209)?

Your help would be greatly appreciated.

Kind Regards,

Biz

 

[pmich]

I have edited the code that I have posted above.
mikerickson and tygrrboi have suggested in their p;postings in the link below to use the values instead of the names of xlrgbcolour.

Change cell interior color according to the xlrgbcolor name in cell

I'm stuck here. Can anyone please show me how to use the rgb name in a cell to make the cell adjacent to it change color? Here's what I've got so far: Sub SetColour() Dim Colour As String, rgbColour() As XlRgbColor, n As Long For n = 1 To Range("A1").CurrentRegion.Cells.Count Colour...

www.mrexcel.com

So, I have edited the following code:

 Dim NowXlClr  As xlRgbcolor

as

 Dim NowXlClr  As Long

Instead of

 NowXlClr = "XlRgbColor." & Src.Range("B" & LTrim(str(RowNm + 1))).Value

I am using the following line of code:

NowXlClr = Src.Range("C" & LTrim(str(RowNm + 1))).Value 'Col C has numbers of xlRGBColour

Instead of

 Selection.Offset(LTrim(str(RowNm)), 2).Interior.Color = XlRgbColor.NowXlClr

I am using the following line of code:

Selection.Offset(LTrim(str(RowNm)), 3).Interior.Color = NowXlClr

and this works.

Is there a way to use the name 'rgbAliceBlue' in the code? I request any expert to please suggest me. Thanks in advance.

 

[RoryA]

Not really. You could probably achieve it in a massively overengineered way by installing tlbinf on your machine and using that, but I can't see the point.

 

[pmich]

@
RoryA
Thanks for the reply, Rory. I will use values only.