Thread: Color Index and RGB Color
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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 With QuoteReply With Quote