tick only one checkbox

[emilemil22]

Hi there,
I am making a userform. I have to checkboxes, checkbox1 and checkbox2. I want to make it such that user can only check one of them at tiime.

And I also want to make it as mandatory question for the user such that he or she needs to tick one of the checkboxes!

thanks for your help

 

[DanteAmor]

For those cases it is best to create 2 OptionButton.


You put the following code on your button to verify:

Private Sub CommandButton1_Click()
  If OptionButton1 = False And OptionButton2 = False Then
    MsgBox "You must select an option."
  End If
End Sub

Example:

 

[emilemil22]

Thanks a lot for your reply. I will amend tge checkboxes into option buttons.

Also I want to make it such that whenever the user ticks option button 2 then everything already entered in textbox1, textbox 2, listbox1 and listbox 2is automatically deleted.

Is it possible to do that?

 

[DanteAmor]

Try this

Private Sub OptionButton2_Click()
  If OptionButton2 = True Then
    TextBox1 = ""
    TextBox2 = ""
    ListBox1.Clear
    ListBox2.Clear
  End If
End Sub