Userform not staying on screen

[sspatriots]

Hi,

I have this code that runs and takes a while, therefore, at the beginning I have a small Userform that pops up at the beginning that says "Please Wait!". At the end of the code, I unload the form. However, while that code is running in the background the form tends to disappear while it is running. I'm wondering if I have an incorrect setting here. I have screenupdating set to false right after the form loads and then back to true once it unloads.

Any ideas are welcome. Thanks, SS

Pleasewait.Show vbModeless

Unload Pleasewait

 

[Micron]

Does your code give anything the focus by making it active or selected?
Another thought - inject a small pause in the line after the form is opened in an effort to give it some stability before disabling screen updating.

 

[sspatriots]

Does your code give anything the focus by making it active or selected?
Another thought - inject a small pause in the line after the form is opened in an effort to give it some stability before disabling screen updating.

Thanks. I put the pause in there for 2 seconds and that seemed to keep it visible. Before, it would just be a shadow or disappear altogether.