Differences concerning BackColor and ColorIndex

[Guest]

I ‘d like to change a line color depending on the Backcolor of a OptionButton
but when I ask :
Color1 = OptionButton1.BackColor

The result do not match to:
Range("AF16").Interior.ColorIndex = Color1

Does sameone knows how can I make it works?

Tanks a lot
Peres

 

[Tim Williams]

Color is a long (RGB) value and ColorIndex is the index (position) of a
color in the workbook color table.

Try:

Range("AF16").Interior.Color = Color1

Note that if you try to set a cell interior color to one which is not in the
workbook color table then Excel will use the "closest" color from the table
instead.


Tim

 

[Guest]

Tanks a lot . You dont imagine how much you help me!

 

[Tom Ogilvy]

Another source of information:

http://www.mvps.org/dmcritchie/excel/colors.htm

David McRitchie's page on colors and Excel.