Help to control Frame visibility on Userform Initialized

Hello Everyone!

I have an user form wit a lot of field counters, the form its too crowded so divided them in two group using a frame control which is holding the less use counters and want them to be visible only if a check box is selected, I found a code that made the frame to be visible when the check box is uncheck, but the problem I have now is that when I open the user form the two frame are visible and only after I click and unclick the checkbox the second fame become invisible with all the controls, looking in to this and other forum I found that it has to be with the initialize event of the user form but I can't find the right code.

This is the code I had so far that made the frame invisible only after I click when the user form is open, but I really want it to be invisible at the time I open the user form.

Thank you in advance for your help or suggestion.

Alex

Please Login or Register  to view this content.

Hi,

Place this code into the UserForm module:

Please Login or Register  to view this content.

This may also be possible by simply setting the visibility property of the frame to false, and then this acts as default when the userform is initialised, hence you don't need code to handle this for you.

I would probably also suggest using this code if your userform is likely to be opened multiple times per session though:

Please Login or Register  to view this content.

This will make the frame invisible every time the form is activated, not only the first time.

Hope this helps

Hi ajryan88,

Thank you for responding to my post, I did it as your instructions and work perfectly. I went the simple way setting up the visibility property to False.
Also, my user form is a multipage and I would have the same frame set up of two or three per page, on another post I read about creating a class module but the code were not clear for me (beginner), it's this the way you will recommend for my setting or is better to set every individual frame.

Thank you in advance for your help on this, I really appreciate it.

Again this is the best place with the best people!!!!

Definitely set every individual frame.

Hope this helps

Thank you very much for your help, it works perfectly, I set every individual frame and love the way it is..

Kudos for you my friend !!!!!

No problems!

Please don't forget to click on the * next to my post to say thanks