Vba code to change checkbox colour when ticked

Alpacino

Well-known Member
Joined
Mar 16, 2011
Messages
511
Hi guys
wonder if you can help.. Does anyone know what the code will be to change a userform checkbox to green when selected.

regards
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Depending on whether you want to change the forecolor or backcolor, you change as appropriate

Thus sample code changes the background to green when it is checked and red when it is unchecked

Code:
Private Sub CheckBox1_Click()
    If CheckBox1.Value Then
        CheckBox1.BackColor = RGB(0, 255, 0)
    Else
        CheckBox1.BackColor = RGB(255, 0, 0)
    End If
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top