Automatically adjustable userform

[dim4x4]

Hi!

I am wondering if the following trick is possble.

Say, I have a spreadsheet with sheets named Project 1, Project 2, Project 3

I want a macro to create and open the following userform:

Project Name Sum (Yes/No)
Project 1 Checkbox
Project 2 Checkbox
Project 3 Checkbox
ОК

Then for example I make changes to my spreadsheet and now it has sheets named Project 1, Project 2, Project 3, Project 4, Project 5

Now, when I run my macro I want the userform to automatically strech down to accomodate new lines and chackboxes, so it looks like:

Project Name Sum (Yes/No)
Project 1 Checkbox
Project 2 Checkbox
Project 3 Checkbox
Project 4 Checkbox
Project 5 Checkbox
ОК

So when I add or remove sheets with projects and run the macro, I want the userform to have exactly the projects I have now, and the size of the form should be just the rigt size to fit those lines.

What do you think?

Thank you!