Minimize button on userform?

[Bob]

Is it possible to insert a minimize button to a userform.
The idea behind this is to be able to keep a userform window open so that
data can be added throughout the day, instead of closing the userform every
time I wish to use other files.

 

[JLatham]

I believe so. First, your userform will need to be displayed as non-modal
(property ShowModal = False).

For your minimize button, use this line of code in its _Click() event:

Application.WindowState = xlMinimized

But I don't know why you don't just click the Minimize button for the Excel
window, unless it's just a matter of added user convenience.

 

[Jacob Skaria]

Bob

Refer the below thread..

http://www.microsoft.com/office/com...69a4&mid=8215b77d-68b5-4166-92dd-31817f6269a4

If this post helps click Yes

 

[Bob]

Thanks guys for that. Thinking about it, it's just as easy to insert a
command button to hide the userform.....much simpler.
Once again thanks for answering the question