Hi All,

Here's my glitch:

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

Any ideas?

Thanks!


--
Soundman
------------------------------------------------------------------------
Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428
View this thread: http://www.excelforum.com/showthread...hreadid=387999