| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to minimize a form using VB
Hi,
How to minimize a form during startup? Public Sub Workbook_Open() Userform.show ....... Many Thanks, Jean. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to minimize a form using VB
Jean,
If you use Load rather than Show it won't be immediately displayed, but will be loaded into memory. Then you can Show it later when you are ready. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Jean Oct" wrote in message ... Hi, How to minimize a form during startup? Public Sub Workbook_Open() Userform.show ...... Many Thanks, Jean. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to minimize a form using VB
Jean,
Sorry, but I don't understand the question. If it's minimized, it is not showing is it? If, as I guess you must be, are referring to not having a minimize and maximize button on a form, then this requires API calls. Stephen Bullen demonstrates the technique I believe in his FunForm example at http://www.bmsltd.co.uk/Excel/Default.htm -- HTH Bob Phillips "Jean Oct" wrote in message ... Then if I want to show the form as minimized window state , can I do so using VBA? -----Original Message----- Hi, How to minimize a form during startup? Public Sub Workbook_Open() Userform.show ....... Many Thanks, Jean. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I minimize | Excel Discussion (Misc queries) | |||
| Minimize?? | New Users to Excel | |||
| 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 | |||
| Minimize the filesize | Excel Discussion (Misc queries) | |||
| window minimize | Excel Programming | |||
Linear Mode
