Build sheet array from checkboxes?

I have a user form with checkboxes, one for each sheet in the workbook. The user selects the appropriate checkboxes then clicks a command button that prints selected sheets.

How do I build the array so it holds only the selected sheets?

I'm using this to print the sheets:

Please Login or Register  to view this content.

sh1, sh2 hold the sheet names:

Please Login or Register  to view this content.

I hope this is enough information, thanks for helping me.

Excel 2000

Hello proepert,

Here is a macro for CommandButton1 on a UserForm to print the worksheets that have their CheckBox checked. Regular Arrays are zero based. The Sheets collection is 1 based. This is way you can not copy the names into a standard VBA array. The macro assumes each CheckBox.Caption is the name of a worksheet and that these are the only checkboxes on the UserForm.

Please Login or Register  to view this content.

Thank you very much. This works well.