View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peres Peres is offline
external usenet poster
 
Posts: 9
Default Differences concerning BackColor and ColorIndex

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

--
Peres