Error 401 - modal form

clozed75

New Member
Joined
Dec 13, 2009
Messages
45
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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

clozed75

New Member
Joined
Dec 13, 2009
Messages
45
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

Legend
Joined
Jun 19, 2002
Messages
63,650

ADVERTISEMENT

Try

UserForm3.Repaint

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

clozed75

New Member
Joined
Dec 13, 2009
Messages
45
.repaint..does a little better..
some colors appear in the background but the core is still poor colored..

any else??
 
Last edited:

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,024
A majorish redesign using MultiPages might be the best way to go.
Barring that, DoEvents after the .Repaint might be worth a try.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,718
Messages
5,660,482
Members
418,580
Latest member
IrishDave2137

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top