Pass information from a userform to a module that then alters visible worksheet columns

Hi all,

I am going around and around in circles and struggling a little bit with my query. I am barely proficient in VBA and much of my coding comes from collecting snippets of info from here and other forums. However, I am struggling with this one.

I have a module that is looking at a few different worksheets in a workbook, taking a range of information from each and updating a worksheet that is used to produce a report (so it is designed to be aesthetically pleasing rather than useful for data recovery.)

I have managed to get all the data onto the sheet, and I am happy with that - even if it is a bit slow.

So then, I want a userform to pop up which has a whole bunch of checkboxes on. The user then selects which columns they want to display on their printed sheet and presses 'select'. My guess is that I need to make an array of the control names for each checkbox (because these corrolate to the headings of the sheet) and then pass these back to the original module which then hides the columns as required before printing it.

userform sample.jpg

this is my code on the userform:

Please Login or Register  to view this content.

and this is my module code:

Please Login or Register  to view this content.

Am I at least on the right track? For some reason the userform opens but after I press the button everything seems to fall over. I am not currently getting any errors, but the userform doesn't close and it doesn't seem to return anything to the module.

Any guidance gratefully received.

@cytop - thanks for that - my apologies, I posted unfinished code. I have progressed this far (having realised that it was easier to take the false values from the the userform to hide, rather than the true ones which I want to see)...

Please Login or Register  to view this content.

Thank you for the sample worksheet - you are correct, it's not something I have used before, but I will have a play and see if it does what I want it to.

Ah yes, that might be a simpler option.

I decided to go with bakerman2's suggestion. I hid the columns by cycling through the checkboxes on the userform and then kicked back to the module finish off - no array required. Might not be very clean, but does all that I need it to.

Thanks for your help folks. cytop, I shall be looking into your code in more detail in the future in case it is useful for anything else.