Hide User Forms

[Djblois]

I use the

[VBA]Forms.hide[/VBA]

all the time to hide a User form before another form opens up. However, the user form doesn't dissapear until the full macro runs. How can I get the Form to disappear before the next one loads up.

[Jacob Hilderbrand]

Note that you are just hiding it and if you don't need it anymore you should Unload it.

[VBA]
Unload UserForm1
[/VBA]

Aside from that, just add DoEvents after your hide row to allow it to hide dissapear.

[VBA]
Forms.Hide
DoEvents
[/VBA]