I understand some of your frustration but don't share all your views. A VBA
userform can include the additional functionality you require, albeit not
directly built in but with API calls. Note though Userform's expose a built
in Resize event.

Typically VBA forms are used as dialogs sitting in front of the main
application, say Excel. In the vast majority of implementations the issues
you mention do not arise.

Sizing a form to screen size/resolution can be an issue in all languages.
Apart from the physical size it can mean resizing/positioning of other
controls, font size etc. Ironically VBA forms have certain capabilities in
this respect that are n/a in other languages. You can even make a Userform
appear as an irregular shape with see through holes and no title/caption
bar!

You might find it interesting to look at a VBA form that includes what
appears to be the particular features you require and some others - an
excellent example is NameManager available from the authors' sites of Jan
Karel Piertese and Charles Williams

www.jkp-ads.com
www.DecisionModels.com

Apart from min/max restore you can also grab a side or corner to resize the
main window, also you can resize the internal listboxes independently.

It's also available on Stephen Bullen's site I referred you to previously.

Regards,
Peter T



wrote in message
...
Peter T:

Thanks very much for your reply.

If this is true, it is totally unbelievable that the highest-level
object implemented by MS in VBA is a severely crippled un-resizable,
un-min/maximizable crippled box, which of course is not a FORM--
because it doesn't have the FUNCTIONALITY of a form.

What do users do with screen resolutions other than the programmer's
do, if the UserForm he designed doesn't fit their screen?

If this understanding is correct, this has got to be one of the most
unacceptable things MS has done.

***

I'll definitely check out your site.

Thanks much again.

***