Auto selection of Check box in one form based on value of combobox from other form.

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.

Dear Norie,

Many thanks for your reply.

Once user press "OK" button in the first form then only second form opens.

For second question, I have not given a thought. But i would like to ensure the second question as well. Thanks for raising this.

Dear Norie,

Second form is opening by selecting the "OK" button from first from. The complete code which I have used til now is

Please Login or Register  to view this content.

This code populates name in text box after selection of ID from combobox in form 1.

Please Login or Register  to view this content.

This code opens the second form when user selects OK button in from1.

Dear Norie,

I want to auto select the correct check box on second form with respect to ID selected in first form. But I am not expert in vba. So I don't know how to do this. I searched and didn't find any way to do this. Could you please help me on this.

Dear Norie,

Please find attached sample file which I have created for you.

Dear Norie,

Second form adds the data into respective sheet based on selection of checkboxe in second form. When you select the checkbox manually, it activates the respective sheet and add data into sheet based on selection of fields in second user form 2.

Many thanks.

Dear All,

Could someone please help me on this?

Thanks

Dear Norie,

Many thanks for your help. It is working fine.