OK...that's actually different. You want to assign the macro to those
drop down's then. Are you using validation for the drop down? or are
you using combobox's?



Matt_2K Wrote:
Thanks for your reply.

I have drop downs linked from C4 to C12, For some reason, the code
doesn't change any of the formatting when I change the drop down
value.

Any ideas?

Thanks.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=481021