Custom User form to add info to textbox's

[Hooty]

I currently have 3 columns: item column, include, exclude. i have a check box assigned to the include and exclude column. i have text box's called include and exclude. anything i add to the Item column can be sent to the wanted text box, by selecting the corresponding check box and then executing code. the whole process is cumbersome, but it works. i want it to work better.

I would like to create a userform that has my list and checkboxes so that they are not tied to cells. I need assistance.

my current code has to be changed every time i want to add rows above, because the check boxes are assigned to cells:

Please Login or Register  to view this content.

[Leith Ross]

Hello Hooty,

It is unlikely anyone will try to reproduce your form's layout and code, which is essential to helping you with this problem. Please post your workbook. If your workbook contains any personal, confidential, or sensitive information then change it before you post the workbook.

[AlphaFrog]

Here is code that will loop through the checkboxes on the sheet and add text to the include textbox.

This is for the Include checkboxes. If the checkbox is in column 1 (change that to suit), and is checked, it will look at the row that checkbox is in and get the text from columns R and S

Please Login or Register  to view this content.

Instead of clicking a command button, call this procedure from each Include checkbox_click procedure

[Hooty]

Here is a copy of the workbook.