Repetitive tasks on forms

[NickNunes]

Howdy!

So I have a form with quite a few entries, and it is pretty brutal to correct EVERYTHING if I have to change something and/or made a mistake. For instance, this code:

Please Login or Register  to view this content.

It simply makes a txtbox visible and it's combobox counter-part invisible. But doing this to every single one of the 36 entries is quite a hassle. Is there any way to make this programing easier?

[AlphaFrog]

Please Login or Register  to view this content.

[NickNunes]

Thanks for that, But I guess I wasn't clear on my question.

The issue is that I have chkNew1 to chkNew36. If I were to switch my code to yours I would need to make this change 36 times. I'm questioning if I there is a way to establish something like:

Please Login or Register  to view this content.

Obviously this code would not work but I guess this explain the gist of the issue. What I'm looking for is compacting all 36 checkboxes into one block of code.

[nigelog]

That will add the checkboxes but not the code required for each. Assigning a class module is probable the way to go so they all act the same.

[NickNunes]

Don't really know how to use a class module, but I'll try to pull it off. I'll leave the thread open for now and comeback if (actually it should be a when...) I need some help

[nigelog]

Have a look at attached - this has a simple way of assigning a common macro to each checkbox using a simple class module with code from cytop

Add this function to a module

Please Login or Register  to view this content.

And change the Class module code to

Please Login or Register  to view this content.

This will give you the control integer you need to pass to the macro to make items visible or not.
If you get stuck post up what you have in a workbook

[nigelog]

You can load the "sets of checkbox, textbox and combobox" together under the control of the class module. This would probably make like a lot easier.
In your userform add this code along with the module code and the class module code

Please Login or Register  to view this content.

Edit: With the help of RoryA finished class module workbook attached

[NickNunes]

My man, this thing worked like a charm!! Thank you so much, saved me a lot of time. Rep up to you