Unusual "subscript out of range error" on userform initialise

Hi everyone.

I'm having a very unusual problem and I'm really hoping that someone might have some ideas. I have been at this for hours and I can't seem to find this particular problem anywhere on the forums.

I'm getting a "Subscript out of range" error when a userform initialises and populates itself with checkboxes.

The thing is, the error is not displayed when the row count (in the form of the variable "i") is below 41. However, when it tries to add the checkbox for 41, I get the error.

I'm very confused. Please help!

Here is the code:

Please Login or Register  to view this content.

What's cBox?

Try this perhaps the rows are not been counted correctly.

Please Login or Register  to view this content.

Thanks

Thank you both very much for your replies!

I didn't realise I forgot to include that variable.

Please Login or Register  to view this content.

This is dimmed as a public variable and as I'm writing this I realise the problem. At two in the morning, my tired brain overlooked this! Obviously the iterations couldn't extend beyond the value that I had set - 40.

Mikerickson, I had never used a multi-select Listbox before. That is incredibly helpful - much simpler! Thank you for taking the time to show me how that works.

Many, many thanks!

Just keep in mind that you have 41 spaces in the cBox variable because you need to start counting at "0" (unless you have explicitly said otherwise)

One last thing, Mikerickson.

I am currently using the caption of the checkbox (cBox) later in my code.

Please Login or Register  to view this content.

With the multi-select listbox, how would I get the value of the selected list-boxes?

Thank you, Fredlo.

Thank you! That is incredibly helpful.