Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dragging userform
When I drag my userform at runtime, an outline of the userform in its old
location is left on the screen. If I dragged it across the entire screen, nothing behind any of the userform locations that I have dragged over would be visible. How can I cleanly drag the userform so that it cleanly appears in only its final location? Thanks in advance for any help. Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dragging userform
You have
application.ScreenUpdating = False in your code before you show the userform. Set it to True before showing the userform. -- Regards, Tom Ogilvy "Ron Dahl" wrote in message ... When I drag my userform at runtime, an outline of the userform in its old location is left on the screen. If I dragged it across the entire screen, nothing behind any of the userform locations that I have dragged over would be visible. How can I cleanly drag the userform so that it cleanly appears in only its final location? Thanks in advance for any help. Ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dragging userform
My application has 17 userforms, and 16 of them work without this problem.
On the one with the problem, application.screenupdating = false doesn't help. The userform with the problem has 18 controls on it and a distinct background color, which is more than any of my other userforms. Is there some sort of a memory problem associated with having too many controls on a form? I guess I can try deleting controls one by one, and see if the problem goes away at some point in time. Please let me know if there is anything more that I can try. Ron Dahl "Tom Ogilvy" wrote in message ... You have application.ScreenUpdating = False in your code before you show the userform. Set it to True before showing the userform. -- Regards, Tom Ogilvy "Ron Dahl" wrote in message ... When I drag my userform at runtime, an outline of the userform in its old location is left on the screen. If I dragged it across the entire screen, nothing behind any of the userform locations that I have dragged over would be visible. How can I cleanly drag the userform so that it cleanly appears in only its final location? Thanks in advance for any help. Ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
dragging userform
Tom suggested using Application.screenupdating=True did you try this? If that still doesn't work, then does your code select a Hidden shee ? If so then this will also cause what you see -- Ivan F Moal ----------------------------------------------------------------------- Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195 View this thread: http://www.excelforum.com/showthread.php?threadid=26985 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
dragging userform
Thanks Ivan,
I had misread Tom's suggestion and assumed that I should set the screenupdating to false instead of setting it to true. It's working fine now, after I set it to true. Thanks again, Ron "Ivan F Moala" wrote in message ... Tom suggested using Application.screenupdating=True did you try this? If that still doesn't work, then does your code select a Hidden sheet ? If so then this will also cause what you see. -- Ivan F Moal ------------------------------------------------------------------------ Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954 View this thread: http://www.excelforum.com/showthread...hreadid=269852 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging | Excel Worksheet Functions | |||
About this dragging... | Excel Discussion (Misc queries) | |||
dragging | Excel Discussion (Misc queries) | |||
Dragging Across | Excel Discussion (Misc queries) | |||
Linking userform to userform in Excel 2003 | Excel Programming |