Creating a User Form with variable number of Controls buttons

Hi All,

Is it at all possible to create a User Form where the number of CheckBoxes will be linked to the number of entries in a cell range?

For example I have a 3 records in the range A:A called "Blue", "Green", "Yellow". I want to have a user form with 3 CheckBoxes with the same caption names.

Please note the number and name of records in this range may vary.

Thanks,
Eduard

Hello Eduard,

Yes, you can create controls dynamically on both a VBA UserForm and also on a worksheet. It isn't clear if your are referring to a worksheet as a user form or not. Let me know if your controls are on a worksheet or VBA UserForm.

Sincerely,
Leith Ross

You may create a userform with lets say 10 checkboxes and assign the code below to the userform. You have to verify the item indices of the checkboxes (under properties listed as TabIndex). The code as it is assumes index 0 to 9 for the 10 checkboxes.

Please Login or Register  to view this content.

Thanks Kuskush! This code might do for a while.

Would there be a more practical solution? Cause I don't want to create a VBA User Form with 100 checkboxes just to make sure that all the records are picked up. Besides that the size of such a User Form will be not very "user-friendly". And the boxes will be dispersed all other the form.

Dear Kuskush,

I have one more thing to ask, if you don't mind.

Would it be possible to run a User Form after or within the a macro?

What I'm trying to get, if to take your example, is to sort the cells A1:A10 first and after that the User Form to pop up.

Thanks,
Eduard

Thanks Andy. That's a good solution. I was not sure the list box will give me the multiple selection choise. Seems like it's all possible.

Still, I'm trying to figure out where do I have to put the code to sort the data prior to the form being initialized.

Thanks beforehand for any advise.

Eduard

Try this:

Please Login or Register  to view this content.

Thanks, Guys. It works either way for me.