Thread: userforms
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default userforms

wrote in message
ups.com...
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