ExcelBanter - Color Index and RGB Color

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Color Index and RGB Color (https://www.excelbanter.com/excel-programming/290426-color-index-rgb-color.html)

X-Men

Color Index and RGB Color

Does anyone know how to convert a integer value colorindex to its RGB color
value in VBA?
Thanks!

Tom Ogilvy

Color Index and RGB Color

activecell.colorIndex = 6
msgbox activecell.Color

--
Regards,
Tom Ogilvy

"X-Men" wrote in message
...
Does anyone know how to convert a integer value colorindex to its RGB
color
value in VBA?
Thanks!

Tom Ogilvy

Color Index and RGB Color

A better answer

msgbox activeworkbook.Colors(39)

where 39 is the colorindex.

--
Regards,
Tom Ogilvy

"X-Men" wrote in message
...
Does anyone know how to convert a integer value colorindex to its RGB
color
value in VBA?
Thanks!

All times are GMT +1. The time now is 10:08 AM.