Change the color of a check box

**aresquare1** · 02-06-2023, 09:41 AM

Can you change the color of a check box if it's checked? I can change the color of the cell that the check box is in but I'd like to change the actual fill color IN the check box. Is this possible? If so, how do I do that?

Thanks,
RR

**torachan** · 02-06-2023, 11:46 AM

assign a small macro to the checkbox.

Sub CHECKSTATE()
With Sheet1.CheckBoxes("Check Box 1")
If .Value = 1 Then
    .Interior.ColorIndex = 4
        Else
    .Interior.ColorIndex = 6
End If
End With
End Sub

Change the color of a check box

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Change the color of a check box

Re: Change the color of a check box

Thread Information

Users Browsing this Thread

Similar Threads

Change check box fill color to unfill and clear check mark

Change tab color with check boxes?

Check boxes that delete other check boxes and change the color of another cell.

[SOLVED] Check dates in column and change cell color

[SOLVED] Check box to change background color when checked

change shape color with a check box.

Check Color Change Macro

Bookmarks

Bookmarks

Posting Permissions