Hi Guys,

I have a spreadsheet that is shared to many other users.

It is essentially a rating tool that has user forms in it with many combo boxes.

The problem I am faced with is that on a desktop it fits perfectly to a screen, however when the tool is opened on a laptop the user form is to big for the screen so some of the buttons are not seen. I would like to know if there is any VBA code that I can put into the spreadsheet that automatically resizes the user form as well as all the buttons, combo boxes , and text automatically upon the spreadsheet being opened.

I am very new to VBA so as much detail in solving this problem would be greatly appreciated.

Thank you

Have a great day

Swadesh