Hide/show columns if checkbox (UserForm) is TRUE

[lukelucky]

Hi everybody,

I'm newcomer into the field of VBA programming and I'm currently trying to figure out this task (for most of you probably easy to solve):

1. load UserForm with 12 checkboxes when one can check criteria he wants
2. macro should then, based on the user's option, hide/show all relevant columns containing detailed information.

Please Login or Register  to view this content.

When I run the macro, it works without breaking down, but it always hide all of the columns. Could you please help me out with it?

Thank you so much for help!

[pjwhitfield]

Can you upload your workbook?

[lukelucky]

thanks for your response!

I'm adding the file where all the classified data have been removed. The main idea about this macro is:

1. User clicks the button and selects the items
2. Based on the selection, only relevant columns remain on unhidded.

Thanks for any suggestion!



Excel_forum, 15 12 2014 FL.xlsm

[pjwhitfield]

You werent actually checking the value of the checkboxes, the following line:

Please Login or Register  to view this content.

simply created a variable and populated it with "Checkbox1", "Checkbox2" etc which never equals True.

You need to cycle through the controls in the form and action accordingly.

Please Login or Register  to view this content.

[lukelucky]

Thank you pjwhitfield, that was exactly what I needed! Works perfectly!