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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

mart37

Well-known Member
Joined
Aug 4, 2017
Messages
1,096
Office Version
  1. 2016
Platform
  1. Windows
Do you use by PROPERTIES the option WIDTH?
 
Solution

The Bear named Joe

New Member
Joined
Jan 15, 2021
Messages
5
Office Version
  1. 365
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.
 

Forum statistics

Threads
1,148,158
Messages
5,745,108
Members
423,924
Latest member
Gazzat

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
Top