Choosing particular Userform controls array in a line of code.

Dear all,

Trust you're all well.

I have a userform with 40 CheckBoxes and they are named as ChBxObj.

I want to write a code that hides the controls that has the value of "Empty".

This code goes from ChBxObj10 to ChBxObj40.

The code I am using is the following:

Please Login or Register  to view this content.

The above code works well but I end up repeating it 30 times and creating a long code.

Is there a way to create a much smaller code that loops the specified controls?

Your assistance on this matter will be highly appreciated.

Best regards,
Filipe

Not tested as no sample document, but something along the lines of:

Please Login or Register  to view this content.

BSB