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

 

[Bob Phillips]

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

 

[×לי]

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

 

[Jacob Skaria]

Refer the below thread..

http://www.microsoft.com/office/com...69a4&mid=8215b77d-68b5-4166-92dd-31817f6269a4

 

[Bob Phillips]

Well what did you expect. If you want the userform, you have to show it.

Bob