#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need some help with userforms T.c.Goosen1977 Charts and Charting in Excel 0 June 30th 06 09:29 AM
I need some help with userforms T.c.Goosen1977 Excel Discussion (Misc queries) 0 June 30th 06 09:27 AM
userforms [email protected] Excel Programming 1 January 11th 05 01:07 PM
Userforms nath Excel Programming 1 May 20th 04 04:53 PM
userforms again... Jo[_4_] Excel Programming 3 September 21st 03 12:31 AM


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"