Dragging form

[Henk]

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?

 

[sinecodap]

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?

Try shut down your system and restart- first solution

 

[Henk]

Sinecodap,

tHenks for your suggestion, but it is happening for several weeks already
and as far as I can remember, I did shut down and restarted my system many
times. Did not help.

 

[Rob Bovey]

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

 

[Henk]

Great! That's it!

tHenks.

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