Thread: Dragging form
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Henk Henk is offline
external usenet poster
 
Posts: 80
Default Dragging form

Great! That's it!

tHenks.

"Rob Bovey" wrote:

"Henk" wrote in message
...
When I drag a form over my screen it remains visible at the place wher it
left. So, if I drag the form 5 times, I see 5 forms on my screen. How can
I
avoid that?


Hi Henk,

This is usually the result of having set Application.ScreenUpdating =
False at some point before showing your form. Make sure to set
Application.ScreenUpdating = True just before you show your form and the
problem should 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