Dynamic Userform (resizing based on checkbox selection)

[gazza365]

Hi,

I have a Userform with several checkboxes on it. I have added a button "Advanced" that opens a second Userform with additional checkboxes.

What I want is for the user to be able to select specific checkboxes on the second userform and then for these to be added to the first userform which will then be resized. (The second userform is basically for advanced options that not every user will want to use. I'm trying to keep the first userform as basic as possible but allow more advanced users to add options to it).

I found some code that adds checkboxes / resizes a userform based on the number of visible worksheets, but I can't figure out how to rework it to do the same based on checkboxes (I'm pretty new to VBA):

Please Login or Register  to view this content.

Any help will be greatly appreciated.

Cheers,
Gareth

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[snb]

If you are pretty new to VBA you'd better explain why you want to do this unnecessary complicated manoeuvre.
You can make visible all kinds of frames/checkboxes in a userform, dependent on who the user is or what the user does. Building a userform on the fly is - generally speaking - not such a good idea.

[royUK]

Nor is have two userforms when one can be used

[gazza365]

I've attached an example worksheet as suggested.

The user clicks the start button on Sheet1 to open the first userform ("userform1"). It has 4 checkboxes. The user can select any of these and then press start (In the example workbook this simply unloads the userform. In my actual workbook this will navigate to the correct sheet based on these selections).

There is a button that says advanced options. When this is clicked it opens a second userform ("userform2") which has a bunch more checkboxes (in my actual workbook there could be up to ten). I'd like the user to be able to select these and for any boxes that are selected to then be added to Userform1.

So for example, if the user checked "OPTION 5" & "OPTION 8", then when they returned to userform1 there would be 2 additional checkboxes (named "OPTION 5" & "OPTION 8"). Userform1 would also need to be resized to fit the extra boxes in.

Like I said I'm kind of new to this whole programming thing so if anyone has any better ideas for how I should do all of this then I'd welcome those too.

Thanks
Gareth