| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm show mode
Hi All!
I have a userform in excel workbook. The workbook itself should be minimized while the userform is active, so I have added the following to the userform initialize event: Application.WindowState = xlMinimized. I am wondering if it is possible to minimize also the userform for a while (to be able to move to another excel workbook)and to activate it again without loosing the data in the userform and without activating the workbook. Many thanks for your help! Eli |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm show mode
You can hide the form rather than unload it,
Me.Hide from within the Userform. When you Show that form again it will pick up with the previous state. HTH Bob "???" wrote in message ... Hi All! I have a userform in excel workbook. The workbook itself should be minimized while the userform is active, so I have added the following to the userform initialize event: Application.WindowState = xlMinimized. I am wondering if it is possible to minimize also the userform for a while (to be able to move to another excel workbook)and to activate it again without loosing the data in the userform and without activating the workbook. Many thanks for your help! Eli |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm show mode
Dear Bob,
This is actually what I have done. The problem is that when I have activated the workbook again, I didnt get back the userform but the excel workbook. Eli "Bob Phillips" wrote: You can hide the form rather than unload it, Me.Hide from within the Userform. When you Show that form again it will pick up with the previous state. HTH Bob "???" wrote in message ... Hi All! I have a userform in excel workbook. The workbook itself should be minimized while the userform is active, so I have added the following to the userform initialize event: Application.WindowState = xlMinimized. I am wondering if it is possible to minimize also the userform for a while (to be able to move to another excel workbook)and to activate it again without loosing the data in the userform and without activating the workbook. Many thanks for your help! Eli . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm show mode
Well what did you expect. If you want the userform, you have to show it.
Bob "???" wrote in message ... Dear Bob, This is actually what I have done. The problem is that when I have activated the workbook again, I didnt get back the userform but the excel workbook. Eli "Bob Phillips" wrote: You can hide the form rather than unload it, Me.Hide from within the Userform. When you Show that form again it will pick up with the previous state. HTH Bob "???" wrote in message ... Hi All! I have a userform in excel workbook. The workbook itself should be minimized while the userform is active, so I have added the following to the userform initialize event: Application.WindowState = xlMinimized. I am wondering if it is possible to minimize also the userform for a while (to be able to move to another excel workbook)and to activate it again without loosing the data in the userform and without activating the workbook. Many thanks for your help! Eli . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm show mode
Refer the below thread..
http://www.microsoft.com/office/comm...d-31817f6269a4 -- Jacob "אלי" wrote: Hi All! I have a userform in excel workbook. The workbook itself should be minimized while the userform is active, so I have added the following to the userform initialize event: Application.WindowState = xlMinimized. I am wondering if it is possible to minimize also the userform for a while (to be able to move to another excel workbook)and to activate it again without loosing the data in the userform and without activating the workbook. Many thanks for your help! Eli |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the filter mode to show the good row count? | Excel Worksheet Functions | |||
| Image (object) offsets in Web show mode | Excel Worksheet Functions | |||
| Show value of variable on mouse-over in debug mode - bug? | Excel Programming | |||
| form.show switches to debug mode | Excel Programming | |||
| Nudging controls in UserForm Design Mode | Excel Programming | |||
Hybrid Mode
