ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userforms (https://www.excelbanter.com/excel-programming/324241-userforms.html)

[email protected]

userforms
 
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

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




All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com