How to make userform disappear while called subroutine is running
 

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!

How to make userform disappear while called subroutine is running
 

Try this

Me.Hide


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=552829

How to make userform disappear while called subroutine is runn
 

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.

"mrice" wrote:


Try this

Me.Hide


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=552829