Followed your great instructions on to resize userform, but i also need to resize the controls at the same time. I have a userform that is Height = 1020 and Width = 1673.
Resizing the userform works, but is useless if the controls do not resize too.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Resize controls in userform when userform is resized
0
Discussion
Your statement isn't a question and it doesn't contain sufficient information to approach your problem constructively. I don't know how you resize your form but if you want to resize the controls on it you will have to modify the Height and Width properties of each one of them, possibly applying the same system by which Height and Width of the form itself is changed. Then, don't forget to apply a similar change to the font in each control.
Variatus (rep: 4889) Sep 11, '20 at 7:53 pm
Answers
0
Selected Answer
I'm not sure which instructions you followed, but I just answered a question like this and included the code snippet to resize the controls as well: