Create dynamic userform with unique value as checkboxes

[YasserKhalil]

Hello everyone
I have a worksheet with values in column D from D2 to the last row. I need to create userform on the fly with checkboxes for the user with each unique value and beside each checkbox a label for each checkbox and at the bottom command button that has a macro to execute say MsgBox "Hello",64

[HansV]

What is the maximum number of rows you expect?

[YasserKhalil]

About 10,000 rows. But the unique values will be maximum 12 values (or even 6 values)

[rory]

You could simply use a listbox with its ListStyle set to fmListStyleOption.

[YasserKhalil]

But I need checkboxes as the user may select more than one option.

[rory]

Try it. Forgot to mention that you will of course want to make the listbox multiselect!

[HansV]

The userform listbox control has a MultiSelect property. You can set it to 1 - fmMultiSelectMulti or to 2 - fmMultiSelectExtended.