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
 
B

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
 
B

Bob Phillips

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

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top