Vba userform - Add new checkbox for each element in Array

[jordan2322]

Hi Guys,

I wish to build a userform that opens and displays check boxes for the user to select.

Each checkbox should be the element value in a one dimensional array

How do I dynamically change the caption on each checkbox and dynamically create/ display the appropriate number of checkboxes for the user?

Kind Regards
Jordan

[jordan2322]

If not a userform even if they were placed onto a defined worksheet. I imagine it would be something like...

Please Login or Register  to view this content.

[jordan2322]

Has anyone done something similar to this before? Perhaps instead of dynamically creating option buttons I should statically create them, dynamically name and make visible?

Regards,
Jordan