I have a library of functions that changes a number of properties of a
userform at run time, including making the form resizable. All said
and done, the library has about 20 functions to control all aspects of
a user form. The core of the library is based on Windows API
functions, but these are all wrapped up into nice, VBA-friendly
wrappers.

See http://www.cpearson.com/Excel/formcontrol.aspx for examples and
downloadable code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 28 Sep 2009 15:28:02 +0200, Gustaf wrote:

Using Excel 2003. There is a Resize event on the UserForm class, but I can't figure out how to resize forms at run-time, by dragging the borders. There's no resize mouse pointer when I hover over the borders. I've been looking for a property to allow resizing forms, but can't find it.

In my case, I want to allow the user to expand the form height (but not width). The minimum height should be the form's startup height.

Any ideas?

Gustaf