2 cells 2 colors

S

Soundman

Hi All,

Here's my glitch:

I've got 2 dropdown/combo boxes in a user form. Both offer variou
color options. The 1st one colors an active cell the correct color tha
is chosen. The 2nd dropdown colors the cell directly to the right or th
active cell in the same manner. My code is pretty crude & not ver
efficient, but it works correctly. The problem is when color 2 is no
chosen. Currently, if a color isn't chosen, I can put an "X" in th
cell, or color it a certain color, but what I want is to color i
whatever the color of the active cell is.

Any ideas?

Thanks
 
E

Earl Kiosterud

Soundman,

Not sure I follow your requirements. If you just want to duplicate the
color of the active cell one cell to the right, how about:

If no color in 2nd box ' (This is psuedo-code,
' you have to make it work in your context
ActiveCell.Offset(0, 1).Font.ColorIndex = ActiveCell.Font.ColorIndex
 
S

Soundman

Thanks for the help, but that didn't work. The target cell had no colo
change. It didn't pop up an error though. :confused
 
S

Soundman

I re-read the code & changed Font.Color for Interior.Color & that's it!

Thank you!!!
 
Top