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?

You need to add a control button. then in the properties window (view
Properties) change the caption of the control button to the text that
you want to apper on the button. then in the button click function wite
your own code to get the min or max values.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=187354

http://www.thecodecage.com/forumz/chat.php

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.


"an01digital" wrote:

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?
.

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



On Sat, 13 Mar 2010 22:39:50 -0800 (PST), an01digital
wrote:

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?

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.



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