View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default UserForm is missing the most basic Win controls. WHAT the?

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

wrote in message
...
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?

***