| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Index and RGB Color
Does anyone know how to convert a integer value colorindex to its RGB color
value in VBA? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help in color index function | Excel Worksheet Functions | |||
| Color Index Code, is there any thing like that? | New Users to Excel | |||
| Custom Color/Color Index | Excel Discussion (Misc queries) | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| How To: Get the index value of the selected color | Excel Programming | |||
Linear Mode
