Userform size bug/horrible setting? Userform shrinking!

Luke777

Board Regular
Joined
Aug 10, 2020
Messages
246
Office Version
  1. 365
Platform
  1. Windows
Hi,

Below is a screenshot of my userform with userform properties. Below that is another screenshot of the same thing except I have changed HEIGHT in the properties window to *100*.
1709034079646.png

1709034112466.png

As you can see, height 100 magically changes itself to 80.4. If I then try typing 100 again...
1709034174687.png

The width of the userform shrinks... and it keeps shrinking the more times I attempt to change 80.4 to 100
1709034229772.png

Why can't I set the values of my userform? Why do they keep changing themselves? Why does changing height change width repeatedly??

Thanks
 

Attachments

  • 1709033886265.png
    1709033886265.png
    228.1 KB · Views: 1
  • 1709033919011.png
    1709033919011.png
    223.3 KB · Views: 3
  • 1709034016779.png
    1709034016779.png
    222.1 KB · Views: 2

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
What happens if you click and drag the resize handles?
 
Upvote 0
What happens if you click and drag the resize handles?
They resize, but I can't specify values, and they eventually shrink (after a wb open close or two) to some random size (annoyingly small) - so thats not much use either
 
Upvote 0
I wasn't suggesting it as a resolution (though sometimes things like that can cure temporary gremlins), I just wanted to know if it would allow you to resize without constraint.

It's not a problem I have heard of before - how long has it been going on, and is it only that one workbook?
 
Upvote 0
I wasn't suggesting it as a resolution (though sometimes things like that can cure temporary gremlins), I just wanted to know if it would allow you to resize without constraint.

It's not a problem I have heard of before - how long has it been going on, and is it only that one workbook?
I've tried two different workbooks and its persistent across both so far - very annoying/bizarre.

I'm wondering if there's some sort of scaling issue on second screens at different resolutions to primary screens?

Not tested the theory out yet
 
Upvote 0
I have monitors with different resolutions and haven't encountered it, but anything is possible.

Which version and build of 365 are you on?
 
Upvote 0

Forum statistics

Threads
1,215,136
Messages
6,123,249
Members
449,093
Latest member
Vincent Khandagale

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top