Hi,
You can initilaize checkboxes to being checked in 2 ways:
- in Design mode, select the checkbox. In the Properties window, set the Value property of the checkbox to True
(If the Properties window is not displayed, go to menu View > Properties Window)
- at Run-time, in the _Initialize sub of the userfform:
Private Sub UserForm_Initialize()
CheckBox1.Value = True
End Sub