PDA

View Full Version : Hide User Forms



Djblois
09-17-2006, 06:24 PM
I use the

Forms.hide

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
09-17-2006, 07:23 PM
Note that you are just hiding it and if you don't need it anymore you should Unload it.


Unload UserForm1


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


Forms.Hide
DoEvents