On Form Open - Check Boxes

[Carly]

I have got a form with some check boxes on that I would like to all be checked initially when the form is opened. The code I am using is as follows:

Private Sub UserForm_Initialize()

    chk_Original.Value = -1
    chk_BranchManaged.Value = -1
    chk_Nationals.Value = -1
    chk_Dublin.Value = -1
    chk_all.Value = -1
    
End Sub

This works, however, they are slightly greyed out & you have to select them twice before you can remove it. Is there anyway that this can be changed so that it isn't greyed out initially?

 

[Trevor G]

Just checked this in 2007 and it seems to check the box. So -1 should work to.

Private Sub UserForm_Initialize()
Me.CheckBox1.Value = True
End Sub

 

[Sektor]

In Form's designer right-click checkbox and select Properties. Set Value = False.

 

[Carly]

Thank you for this...so simple, but the True/False instead of 0/-1 works fine.