Minimize button on userform?
 

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

Minimize button on userform?
 

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.

"Bob" wrote:

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

Minimize button on userform?
 

Bob

Refer the below thread..

http://www.microsoft.com/office/comm...d-31817f6269a4

If this post helps click Yes
---------------
Jacob Skaria


"Bob" wrote:

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

Minimize button on userform?
 

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
--
Bob


"Jacob Skaria" wrote:

Bob

Refer the below thread..

http://www.microsoft.com/office/comm...d-31817f6269a4

If this post helps click Yes
---------------
Jacob Skaria


"Bob" wrote:

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