vba checkbox name, value, checkbox_change()...펌

Try this method to load and show the form (this goes in a normal module): Sub main() Dim myForm As ComplaintEntryForm Set myForm = New ComplaintEntryForm myForm.Show Set myForm = Nothing End Sub In the UserForm's own module, add the following: Private Sub CheckBox1_Change() readData End Sub Private Sub CheckBox2_Change() readData End Sub Private Sub UserForm_Initialize() Me.CheckBox1.Value = True Me.CheckBox2.Value = False End Sub Private Sub readData() Debug.Print Me.CheckBox1.Name Debug.Print Me.CheckBox1.Value Debug.Print Me.CheckBox2.Name Debug.Print Me.CheckBox2.Value End Sub