Vba code to change checkbox colour when ticked

[Alpacino]

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

 

[Momentman]

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

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

 

[Alpacino]

Thank you