UserForm is missing the most basic Win controls. WHAT the?

[baobob]

I'm a relative newbie (or maybe a relative to a newbie).

UserForm is totally missing the most basic Windows controls--minimize
and maximize buttons, and the user can't even resize it.

And I can't seem to find any relevant properties in the property
inspector. I mean, what the?

Is it programmer error as usual, and I haven't selected the correct
component from the palette?

If that is the case, then why does the (o/wise fine) VBA environment
default to such a stupid component?

I mean, we're trying to write some *applications* here. Or does
Microsoft want us to jump ship?

***

 

[Peter T]

That is by design. No doubt it was not expected you to need such features
with a VBA userform. However they can be implemented, see Stephen Bullen's
FormFun.zip

http://www.oaltd.co.uk/Excel/Default.htm

Work out the 'flags' you need and set them in the form's initialize event.

Regards,
Peter T

 

[Peter T]

correction -

Work out the 'flags' you need and set them in the
form's initialize event.

better to do that in the form's Activate event.

Peter T

 

[baobob]

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.

***

 

[Peter T]

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