ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dragging form (https://www.excelbanter.com/excel-programming/411047-dragging-form.html)

Henk

Dragging form
 
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

Dragging form
 


"Henk" wrote:

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

Dragging form
 
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.



"sinecodap" wrote:



"Henk" wrote:

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


Rob Bovey

Dragging form
 
"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



Henk

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





All times are GMT +1. The time now is 05:28 PM.

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