VBA Userform Re-size or Scroll Bar solution

I have made two different attempts to resolve a problem I am having with my userform not displaying correctly on different screen resolutions.

Please Login or Register  to view this content.

None seem to work - can any point out the error of my ways?

Sample workbook attached.

Cobbling together your 2 attempts where the userform is sized to the app window and the scrollbar to scroll only to show all available controls...

Please Login or Register  to view this content.

You only need to define the ScrollHeight as basically the top of the 'lowest' control + its height + a little for luck.

Please Login or Register  to view this content.

Changed the code to Userform1 to refelct name of form and now get "Ambiguous Name Detected ;UserForm1_Initialize

And if you have an existing Initialize event then the codes must be combined into 1.

Brilliant - thanks.

Just entered the code below and the form now fits the width of the screen but I need to see some of the spreadsheet behind it. What should I do to reduce the width by 50%?

Please Login or Register  to view this content.

Brilliant - thanks.

Just entered the code below and the form now fits the width of the screen but I need to see some of the spreadsheet behind it. What should I do to reduce the width by 50%?

Please Login or Register  to view this content.