Add multiple checkboxes to a userform frame acc. to found items

[stojko89]

Hello, me again

I'm trying to do the following:
Once the a found cell is approved to the IF statement, add a checkbox with the value of the cell on to a userform frame.
Looking on, if there is another one that is approved, add a checkbox with the value of the cell under the first added checkbox.
I've managed to do this:

Please Login or Register  to view this content.

This adds the first checkbox correctly, but I don't know how to carrie on, so it would add others, one under the other, as many as found on the sheet. Up to like 10max....
Any suggestions?

BR, Denis

[Arkadi]

Use a loop to add multiple ones, for example "For i = 1 to 10"

Then change

"Predmet1" in the code to "Predmet" & i

Then your .Left stays the same, but .Top would equal (i-1) * 15 + 6

the +6 means starting at a .Top of 6, the 15 you have to play with to see if the spacing is right.

[mikerickson]

Rather than adding checkboxes to the frame you could add items to an existing multi-select ListBox with the ListStyle fmListStyleOption.

Please Login or Register  to view this content.

[stojko89]

Hello again,

Sorry for the late replay. I was just working on this again.
Thank you Arkadi for the help, but I'm going to use mikerikson's suggestion, because it simplyfies the events after.

Thanks again to both!
BR, Denis