Newbie: How to make the userform Minimize button visible?

[Frank Krogh]

I have examined my Userform properties window but cannot find where to make
the Maximize, Minimize and Close buttons.

How are these buttons defined and made visible?


Frank Krogh

 

[Mike Fogleman]

The Close button is made from the ToolBox by adding a CommandButton object
to the UserForm. As for Min & Max I don't believe you can do that because
the UserForm has the focus and you have to deal with it before you can
continue. However, you can show the UserForm as vbModeless (UserForm1.Show
0) which will allow you to work outside the UserForm while it is visible.
Mike

 

[Edward Ulle]

I have been search for the same thing and stubbled upon this web site
"Steven Bullen's Excel Page" FormFun, thanks to Valeria's previous
posting.

http://www.bmsltd.ie/Excel/

Sometimes you just have to search past posting to get a clue.

I've tried it and it works.