How do I create minimize and restore buttons on a user form

[Guest]

Using Excel 2003 SP1 (part of Office Professional Edition 2003)

I would like to understand how to create a user form in Visual Basic for
Applications that contains not only the Close Button in the Title Bar (the
default), but also the Minimize and Restore Buttons as well.

Additionally, is it possible when the user maximizes a user form (by
clickiing the maximize button) that all subsequent forms are automatically
maximized when the application opens them (i.e. form.Show)? In other words,
without the user having to click the maximize button on each of the user
forms.

 

[Township of East Hanover]

Additionally, is it possible when the user maximizes a user form (by

clickiing the maximize button) that all subsequent forms are automatically
maximized when the application opens them (i.e. form.Show)? In other
words,
without the user having to click the maximize button on each of the user
forms.

You would have to save the setting somewhere and then when the workbook
opens retrieve the setting so that when you call show inside the open event
you can refrence the setting and maximize the form.

 

[Doug Glancy]

Stephen Bullen's FormFum shows how to create the min/max buttons.

Also, do a Google Groups search for "minimize userform excel API" or
something along those lines and you'll see some helpful threads.

hth,

Doug Glancy

http://bmsltd.ie/Excel/SBXLPage.asp