Resize User Form

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,457
Is there a way of resizing a user form dependent on the size of a listbox control on the form?

Also, is it possible to resize a listbox based on the number of records on it?


Thanks
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
4,037
Office Version
  1. 365
Platform
  1. Windows
Well, for the first question, you can. if you set the userform height to a value(100) +listbox1.height or something like that
 

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,317
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top