How to make userform disappear while called subroutine is running

C

Cornelia

How do I call a module from a userform and have the userform disappear from
sight? Now I call the subroutine, it runs and then I UNLOAD the userform.
But the subroutine takes awhile to run and having the userform show is
distracting.

Again, I am a novice so I appreciate any help anyone can provide. Thank you!
 
C

Cornelia

Thanks for your advice. I put Me.Hide on line before I call the subroutine.
It took awhile, but it went away after a minute or so, but it seemed like my
routine stopped about the same time. I am really a novice, so it might have
been a co-incidence.
 

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

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Passing Userform Control to Subroutine 2
Need Help with a VBA subroutine 0
Userform dropdown doesn't go away 0
Code after the "Unload Me" call? 2
Check if UserForm is loaded? 11
Help with Calling a subroutine in the ThisWorkbook Class 6
Auto closing UserForm 3

Top