Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging | Excel Worksheet Functions | |||
Dragging VLOOKUP | Excel Discussion (Misc queries) | |||
About this dragging... | Excel Discussion (Misc queries) | |||
dragging | Excel Discussion (Misc queries) | |||
Dragging Across | Excel Discussion (Misc queries) |