unload userform problem

**leonidas** · 07-05-2006, 08:31 AM

Hi,

I have some userforms and some code to get those userforms to work.
In a few userforms I end the code like:

...
Unload UserForm2
UserForm3.show

And when I push the CommandButton2 (=Cancel) on this UserForm3, UserForm2 is back again.

The only problem is that the "Unload Me" command doesn't work so well. UserForm3 comes in front of UserForm2, but UserForm2 doesn't disappear?
Also when I drag Userform2 through the screen, before I push any button to activate the code, the userform is spread out all through the screen. When I try this with a userform that is not connected to another userform, this speading out doesn't happen.
Does someone know what the problem is? Thanks in advance!

Jim Rech · 07-05-2006, 08:55 AM

"Me" doesn't unload until the code in "Me" is done running. I'd suggest the
you put UserForm3.show in a sub in a standard module and that you call that
sub with an OnTime macro:

Unload Me
Application.OnTime Now, "SubToShowUF3"

--
Jim
"leonidas" <[email protected]> wrote in
message news:[email protected]...
|
| Hi,
|
| I have some userforms and some code to get those userforms to work.
| In a few userforms I end the code like:
|
|
| Code:
| --------------------
| ...
| Unload Me
| UserForm3.show
| --------------------
|
|
| And when I push the CommandButton2 (=Cancel) on this UserForm3 the
| previous userform is back again.
|
| The only problem is that the "Unload Me" command doesn't work so well.
| UserForm3 comes in front of the previous userform, but the previous
| userform isn't really disappearing?
| Does someone know what the problem is? Thanks in advance!
|
|
| --
| leonidas
| ------------------------------------------------------------------------
| leonidas's Profile:
http://www.excelforum.com/member.php...o&userid=35375
| View this thread: http://www.excelforum.com/showthread...hreadid=558400
|

**leonidas** · 07-05-2006, 11:55 AM

Hi Jim,

That solution worked for me! Thanks!
But I still have a problem with dragging those userforms (see attachment).
Do you (or someone else) know how to solve that problem?
Thanks in advance!

**leonidas** · 07-05-2006, 12:35 PM

Hi,

I have solved the problem with dragging userforms over the screen.
I used "Application.ScreenUpdating = False" and then the userform doesn't update too. By ending the macro with "Application.ScreenUpdating = True" the problem was solved!