Hi All,

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

If user has selected ID "001" from one form and in the second form ,"001" should be ticked automatically and other check boxes should be deactivated as well.

I have completed the coding of First form but I am not able to get any solution for auto ticking of check boxes.

Please help.

Many thanks.