Capture value of corresponding Textboxes of a Checked Checkboxes to Worksheet

[rakotonirinas]

Hello everyone,

I would like some help please in capturing the data within a textbox next to a checkbox to a worksheet. So if 4 textboxes are checked then there will be 4 rows of data - starting from the value of the textbox next to the first checked checkbox - on the worksheet and so on. No box checked means that no data will be copied and paste on the worksheet.

I have tried to do a nit of macro but it's useless and I don't think it fits the purpose. Your help is much appreciated.

As you can see on the Database worksheet (sample attached). I would like to both capture the value within the next checked box but also the name of the checkbox itself.

Thank you

Capture.PNG