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.
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.
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]