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

--
greig_st
-----------------------------------------------------------------------
greig_sts's Profile: http://www.excelforum.com/member.php...fo&userid=1583
View this thread: http://www.excelforum.com/showthread.php?threadid=27326

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

"greig_sts" wrote:


Hi Folks,

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

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?


--
greig_sts
------------------------------------------------------------------------
greig_sts's Profile: http://www.excelforum.com/member.php...o&userid=15835
View this thread: http://www.excelforum.com/showthread...hreadid=273261

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