userform in the VB environment

A

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

joel

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

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

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