Resizing a userform

J

jj

Hi,

I have a userform, that possibly needs to resized by the
user.
Does anyone know a good way to resize a userform in such
way that controls don't "jump around". Or, even better,
way resize also the fonts with the form (ie. magnify).

Thanks in advance,
JJ
 
P

Perry

There's a CFormChanger class roaming the internet.
Deals with all kinds of resizing issues of VBA userforms.
"Things they said weren't possible..."

Stephen Bullen has an excellent MS Excel example on his site, making use
of the CFormChanger class.

http://www.bmsltd.co.uk/Excel/Default.htm
Take the link: "They said it couldn't be done" and it's the first topic on
the subpage.
FormFun.xls

Resizing UserForms is certainly one of 'em ...
The 'magnifying' functionality y're talking about, is valid for the Caption
proporty
in this above project not for the entire UserForm though :(
Requires a good deal of VB/VBA knowledge to make it work, though ...

Krgrds,
Perry
 
Top