Automatically change the text color when you check out the checkbo

[Guest]

I have few checkboxes and what I am trying to do is to write a macro so that
every time I check out one of the check boxes the text (statement) that is
associated with that specific checkbox changes color.
Also I have a macro that automatically copies and pastes info from one sheet
to the other however if the text is in red it will paste it but in automatic
black color. How can I get it paste in color.

 

[Guest]

Half the answer: you need to do a "Paste Special" and click on value only.
That way the cell will keep the color format.