How to capture value from Check Boxes

You can check the state of the checkboxes via the userform object before you unload it. So you main routine may look like this,

Sub Main()

Userform1.Show

msgbox Userform1.Checkbox1.Value

Unload Userform1

End Sub