Auto Disappear of all checkboxes in 2 form except selected value from combobox in 1 form

Dear All,

I have two user forms in my excel sheet. In one form user needs to select name from combo box and ID of user auto populates in text box. When users press OK button in this form, it opens another form which has around 40 check boxes. Check box get auto ticked based on selection of ID in previous form. Based on selection of check boxes in this form, respective sheet get activated.

I don't want user to see all checkboxes. User should be able to see checkbox of his own ID. Rest of checkboxes should disappear.

e.g. If user has selected ID "001" from one form and in the second form ,"001" should appear and other check boxes should be disappeared as well.

Please find attached demo sheet.

Originally Posted by excel_126

... it opens another form which has around 40 check boxes. Check box get auto ticked based on selection of ID in previous form. ... I don't want user to see all checkboxes...

Then why have one? It seems you're going to a lot of trouble to have a checkbox that is only a refection of one selection in the combobox.

Checkboxes are to give a user several options. If there is only one option, then why have one?

Wouldn't it be better to give feedback in a label that shows the user which sheet the info is coming from?

To disable all but the selected checkbox, in the CheckBox CommandButton1 click event

    For Each ctl In Completetask.Controls
        If TypeOf ctl Is MSForms.CheckBox Then
            If ctl.Caption = Me.ComboBox2.Value Then
                ctl.Value = True
                'Exit For
            Else
                ctl.Enabled = False
            End If