Resize UserForm and controls

When you open a workbook with a UserForm that you create in Excel for Windows you will notice that you think you're getting old because the UserForm will popup very small and you need an optical device. You can copy the code below in the UserForm module and the second code block into a normal module of your workbook to change the size automatic when you open the UserForm on a Mac. Change the 1.333333 in the code if you think it is too big or too small.

Copy the code below in your UserForm module :

Copy the code below in a normal module :

If you have copy the code in the correct location you will see that if you open the Userform in Mac Excel the UserForm and controls are bigger. If you open the UserForm in Excel for Windows the code will not run because we test the OS with the conditional compiler constant #If Mac

Web design by Will Woodgate