userform in the VB environment

  • Thread starter Thread starter an01digital
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top