Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
no minimize or close button rowland Excel Discussion (Misc queries) 1 April 22nd 09 04:07 PM
Minimize UserForm Howard31 Excel Discussion (Misc queries) 0 December 17th 08 10:10 PM
Minimize a UserForm SailFL Excel Discussion (Misc queries) 1 August 21st 05 12:45 AM
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit Daniel Excel Worksheet Functions 2 July 9th 05 03:35 AM
Use the X button on a userform Greg B Excel Discussion (Misc queries) 3 May 16th 05 09:19 AM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"