Error 401 - modal form

[clozed75]

Hi,
I've done a userform with a "please wait" message while code is processing.

I would like this userform to lay over other two userforms previously loaded.

I think it is a matter of vbmodeless..but it is returning me a 401 error ..can't show a non-modal when a modal is displayed..

if I have understood something I should unload all the forms and let the "please wait" form alone.

is it correct?
is there any other way i can get out of it ?

thnx in advance


Cloe

 

[Simon Lloyd]

I believe ALL your forms need to be non modal.

 

[mikerickson]

Have you tried hiding the modal userform?

 

[clozed75]

by hiding all the modal forms the code runs without errors but the non modal is not correctly loaded and remains white (only the edge of the form appear).. can this be a problem of graphic memory or similar?

Cloe

 

[VoG]

Try

UserForm3.Repaint

after loading the modeless form - change UserForm3 to the name of the form.

 

[clozed75]

.repaint..does a little better..
some colors appear in the background but the core is still poor colored..

any else??

 

[mikerickson]

A majorish redesign using MultiPages might be the best way to go.
Barring that, DoEvents after the .Repaint might be worth a try.