Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no minimize or close button | Excel Discussion (Misc queries) | |||
Minimize UserForm | Excel Discussion (Misc queries) | |||
Minimize a UserForm | Excel Discussion (Misc queries) | |||
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
Use the X button on a userform | Excel Discussion (Misc queries) |