Generate RGB combinations from Rng.Interior.ColorIndex vlaue

V

vicky

I need a vba code which geneartes RGB combination from
Rng.Interior.ColorIndex value. The reason why i want to do this is
because Interior.ColorIndex value differs for 2003 and 2007 .

I am getting the colour from excel file by Rng.Interior.ColorIndex
value and then applying it to powerpoint charts . but when i try to
do it for 2007 version powerpoint charts it is not applying the
specified colours .
 
P

Peter T

Interior.ColorIndex doesn't differ between 2003 and 2007, but in 2007 the
actual colour of a cell may not be the same as the palette colour associated
with the colorindex that's applied to the cell format. That's because,
unlike earlier versions which can only be formatted with a palette colour,
2007 cells can be formatted with any colour.

Try this instead -

lngClr = Rng.Interior.Color

Have you looked into using Themes for your 2007 app's

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get a color name from any RGB combination? 50
Setting cell colors using RGB( ) function 1
retrun an RGB value to a specified cell 4
Application.Evaluate (works with SIN but not RGB) 4
VBA to run all variable combinations in a calculation model and store result 6
List 6-of-36 combinations matching 4 (errata) 1
RGB colours settings have changed 2
RGB Colours in Excel 2003 1

Top