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.
Bookmarks