Automatically Change Font Sizes on Userform

I have a Userform that includes labels, textboxes, combo boxes, dropdown boxes, option buttons and command buttons. I was asked to change all the fonts on the form to size 12 (it was defaulted at size 9). Is there a VBA code to automatically change all the font to size 12 at the same time, instead of going into each one and changing them manually? Any guidance would be greatly appreciated. Thanks.

Jeff, this is perfect, however, with the form showing text at the 12 point, it is now overlapping each other and being cut off. Is there a way to fix this automatically as well, or do I need to go into the userform and manually enlarge each control?

This updates the fonts and makes everything 25% bigger and spread out.

Please Login or Register  to view this content.

Here's another idea. You can bring up the form in the VBA window, click F4, click on the form, then hit CTRL+a. This selects all controls at once. Then on the left Properties panel you can select Font and update the size. It's manual but you do them all at once. You would still have to manually update sizes and positions, but then the code stays clean.

Thank you so much, Jeff! This works!