convert code from populate items into multiple tools on userform to copy into sheet

hi
I got the help from previous threads from MR.jindon ,mohadin. the orginal code is for Jindon and the modifying is for mohadin
currently code populate items into all comboboxes & textboxes based on selected the specific sheet from combobox13. now I added combobox14 after I select the sheet from combobox13 and populate the items into all tools (comboboxes & textboxes) and when I filled all tools or specific tools should copy to specific sheet based on selected from comboboxe14 from row2 . so I truly appreciate if any body gives me the modifiying code or alternative into command button to copy for specific sheet .

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Combobox for TT and PR are redundant as there is only ever one selection so they could be textboxes.

To output to file, just select "Com"

This line is looping through the comboboxes relating to "COM" which are 1,4,7 and 10.

There is no code relating to textboxes as there aren't any on the Userform.

Combobox for TT and PR are redundant as there is only ever one selection so they could be textboxes.

I did not change the Userform but merely suggested that it was an alternative