Minimise/Maximise Controls in Forms

[greig_sts]

Hi Folks,

Having a bit of a moment trying to tidy up a VBA form that I a
creating. I think the answer is going to be obvious but can't find i
anywhere.

After creating a form I get the "X" for closing the form but do not ge
the minimise and maximise buttons.

Where do I find the option to switch these on

 

[Frank Kabel]

Hi
AFAIK there's no such option. You need some more code (API function calls)

 

[Stephen Bullen]

Hi Greig,

After creating a form I get the "X" for closing the form but do not get
the minimise and maximise buttons.

Where do I find the option to switch these on?

It takes some windows API calls (see the formfun.xls example on my site),
but even then isn't great, as the form is maximized and minimzed to the
Windows Desktop, not within the Excel desktop.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk