View Single Post
 
Old 03-11-2014, 03:35 PM
saltlakebuffalo saltlakebuffalo is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Feb 2014
Posts: 11
saltlakebuffalo is on a distinguished road
Default UserForm autofit / autoscale into any screen

Dear All;
I have an UserForm in excel VBA. On this UserForm there are many kinds of objects like textboxes, labels, comboboxes, optional buttons, checkboxes, etc.. Now I hope that this UserForm, when activated, can auto-scale and autofit into any monitor screen, whith all objects on it being auto-scaled accordingly. Rght now I can have the UserForm itself autofit into a screen, but all objects on it remains unmoved or unscaled. Is there any such a code or approach so that all objects and the form can autofit / autoscaled? Thank you so much.
Reply With Quote