userforms

[john.9.williams]

Hi,

I have a program that unloads/reloads various userforms, when certain
userforms are loaded/reloaded something strange happens that i wish to
check with your good selves. If you click on a form and move it across
the screen there are endless useforms exactly the same behind it in
like a trail effect, is this normal or have i loaded the forms wrong.

regards

john

 

[Rob Bovey]

I have a program that unloads/reloads various userforms, when certain
userforms are loaded/reloaded something strange happens that i wish to
check with your good selves. If you click on a form and move it across
the screen there are endless useforms exactly the same behind it in
like a trail effect, is this normal or have i loaded the forms wrong.

Hi John,

This means that you have Application.ScreenUpdating set to False when
you display the UserForm. Make sure that Application.ScreenUpdating is set
to True before showing the form and this problem will go away.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm