read out of dynamic amount of checkboxes

Hey people!

I have a bit of a weird problem here and since I am a VBA newbie I thought I'd post my question here.

I have a userform that is populated with horizontal rows of checkboxes. The amount of checkboxes is based on a number the user puts in. The amounts of rows is based on what catagories the user puts in. A user can put in up to 10 catagories, which forms 10 lines of checkboxes on the userform. Now... when the user clicks "next" the read out of the checkboxes has to be saved to a table on a sheet, corresponding with the checkboxes lay out, in 1's and 0's.

What I have so far is almost everything, except for the fact that the read out of the checkboxes is all in thesame row on the sheet where the read out is saved, while I want it to correspond with the amount of rows of checkboxes on the form. (Gets complicated to explain...)

In simpler terms... If my user form looks like this

Naamloos.jpg

I want the read out to have thesame amount of rows and columns. Also... If a user decides not to put in category 5, which creates a blank line, it should skip a line in the read out table.

This is my code so far.

Please Login or Register  to view this content.

The difficulty is that the amount of categories as well as the amount of checkboxes is dynamically.

Hopefully someone can guide me a bit into the right direction.

Hi,

try this (dynamic label creation inserted, shorter code)

Please Login or Register  to view this content.

Hi,

I must have misunderstood you, please have a look on the attached sheet, if the number of labels/categories is different in Blad3 just change it and reupload, thanks.

nasdrasil.xlsm