Resizeable form

Is there a way to make a form resizable?

Thanks
Matthew

 

Yes, but its tedious. In the UserForm's Resize event, adjust the Left and
Top properties of the controls on the form. You may also have to adjust
their width and height properties.

 

How do I know how much to move the controls & or how much bigger to make
them? Any tips?

Thanks for the quick response
Matthew

 

Since all forms are different, you just have to experiment. You may want
some things to be fixed while other things move. You may want some things to
move in relation to another object. You can do things like process controls
in a For loop, making them a percentage of the Form's size/position, or some
other control. Use some formula to size/position them.

 

Here is a link to some auto form resizers.
http://www.soft411.com/software/form-resize.html
Regards - Nathan

 

How would I fire that event (userform_resize)? by some other control? I
guess I have an idea about the size change. The mousedown event could save
the x & y coord. then the mouseup event could save the changed x & y coord,
and the difference is the resize amount.

Nathan, I don't have access so I couldn't use the free resize control I
found from your link. were there other free ones?

Thanks for your help
Matthew

 

The normal userform in VBA is not resizable.

 

Maybe ActiveResize Control Lite (Free)
http://www.vbgold.com
Regards - Nathan

 

Or you can just go here:

http://tinyurl.com/2davc

 

While its true that the cursor doesn't change for dragging the size, there
are other ways. The help file gives one, using the form's Click method to
run code that increments the size.

 

When the size of the form changes, the event fires. Normally, the user would
drag the border. But in acad vba, you can't do that, see my post to Jorge.

 

Or you can just go here:

http://www.vbdesign.net/modules.php...ats=29&view=128

 

sorry ..

http://www.vbdesign.net/modules.php?s=&name=Code_Trout&cats=29&view=128

 

To resize the form copy the code from
Jose's link into your form code.
While running the form grab the lower
right corner and start moving the mouse.
Neat stuff right?


--
Chuck Hardin - Burger King Employee of the Quarter!

any speling mistakes are the responsibility of my dog and should not
reflect on my inteligence.
[glow=green]
'Copy/Paste Code' (http://www.copypastecode.com) [/glow]

 

I should have said:

"The normal userform in VBA is not resizable, unless you code the resizing"