User form box too small to use - HELP

These subs need to be in the userform's code module and not a standard module.

Please Login or Register  to view this content.

The only code that you have there that controls the size and position of the userform is

Please Login or Register  to view this content.

If you put a breakpoint on the line that says

Please Login or Register  to view this content.

and then step through you'll see that the userform changes size and location once the initialize sub ends. If you have other code that you haven't posted, could that be changing the values again? Stepping through your code should enable you to see which code is running when the userform loads.

Why don't you use VBA to query the values of application.height and application.width and see if that throws anything up. I noticed that when I mocked up a userform and used your initialize code, the form limits at the right and bottom were off the screen, whereas my maximised Excel application was not. Perhaps your original computer can't handle instructions to display something outside the limits of the screen. What happens when the Excel application is not covering the entire screen and you load the userform? Based on your code I would expect that no matter where the Excel window is located on the screen, the userform should display in the top left corner of your screen and be the same size as your Excel window. Is that what happens?