Allow User to Adjust UserForm Size?

[bdmangum]

Howdy,

Using Excel 2003, is it possible to allow a user to adjust the size of a userform? I was recently asked by a user of a form I created if I could make it so they can resize the form similar to an Internet Explorer window. I am unaware of a method for accomplishing this task. Does anyone know how to allow for this? Or just any ideas for starting points?

TIA,
BD

 

[bdmangum]

I just found this website which contains a zip file called "Resizer". The sample file provides all the code needed to resize a form.

http://www.bmsltd.ie/Excel/SBXLPage.asp

Hope this helps anyone else with the same goal.

BD