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.
|