Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need some help with userforms | Charts and Charting in Excel | |||
I need some help with userforms | Excel Discussion (Misc queries) | |||
userforms | Excel Programming | |||
Userforms | Excel Programming | |||
userforms again... | Excel Programming |