Widening the user form during design/create of the user form in vba excel

The Bear named Joe

New Member
Joined
Jan 15, 2021
Messages
5
Office Version
  1. 365
I apologize if this question or problem has been asked before but I could not find it in the database. I have a 35 inch monitor. When I try to widen a user form, occasionally the user form will simply not go any further in width. This is during the design of the user form. I do not at this time want to control the user form width at the time of running the macro.
Other user forms of the same workbook are wider and have been adjusted without a problem. This happens to me occasionally and my fix for this has been to scrap the current project and start all over again. However I am just simply tired of doing the reconstruction of a perfectly good working application. Doe anyone know what I have done wrong or what I am missing? Your assistance in this is greatly appreciated. Thank you in advance.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Do you use by PROPERTIES the option WIDTH?
 
Upvote 0
Solution
Mart37 your suggestion worked. However, I'm not sure why the dragging with the mouse quit working for this form. Oh well, does the job for what I wanted. Thanks very much and regards.
 
Upvote 0

Forum statistics

Threads
1,214,592
Messages
6,120,433
Members
448,961
Latest member
nzskater

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