userform in the VB environment

[an01digital]

Hi,

In Excel 2007 I created a userform in the VB environment. Yet, in the
properties I can find a item where you can turn on the max/min button
or even show one. Does anyone know how these can be turned on?

 

[Mike H]

Hi,

You have to program that yourself. Have a look here.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=165

A Point that isn't mentioned on the site.

Set the the 'ShowModal' property to false or minimising is a bit of a waste
of time because you can't do anything else in the workbook.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Chip Pearson]

You can't do it directly with VBA. You need to call the Windows API
functions that manipulate the window Style bytes. I have
documentation, example code, and a demo workbook available at
http://www.cpearson.com/Excel/FormControl.aspx .

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com

 

[Dennis Tucker]

From a little experience, I've used another's solution for doing this. I
was able to add support for the Min/Max buttons, a form icon and taskbar
support. Although it did work, it was not perfect. There were conditions
that caused some of these things to fail.