Check Color Change Macro

[scdve]

Is there a way I can make my check box change color when it's checked? I'd like to have it uncolored and then turn green when checked. Not the cell, but the checkbox itself. I can't seem to make the check box part of the cell, if that would be an easier route to go please let me know. If I have to turn the cell green and not the check box, I'd love for the whole row to turn green. I attached a sample of the sheet I'm trying to build. Thanks for any help you guys can give.

[VBA Noob]

To do the whole row I would link the cell the checkbox to the cell e.g P5 etc and then use conditional formatting e.g

$P5=True

Otherwise you could try

Please Login or Register  to view this content.

Or if you use the form buttons you could adapt the code from here

http://www.ozgrid.com/VBA/excel-macr...ine-button.htm

VBA Noob

[Leith Ross]

Hello scdve,

You can't change the color of the check box itself. You can only change the back color of the check box container. I have added the macro shown here to the each of your check boxes. This will color the row green when it is checked and restore the row back to either the white or the clay(?) color. Download the attached file.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[scdve]

Perfect! I love both ways. Thanks for all the help!