Userforms resizing and reformatting on different monitors

Garrek

New Member
Joined
Aug 22, 2019
Messages
49
I have a few userforms on a sheet, but when I use them on a different sized monitor, they resize (often much larger) and the contents are not organized well like I have them set. As soon as I go in the VBA Editor and resize them back to normal, they take on all their old formatting, but I was hoping to find a way to "lock" the userforms so I dont have to worry about this. Ideas?
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,102,556
Messages
5,487,535
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top