dragging userform

[Ron Dahl]

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

 

[Tom Ogilvy]

You have

application.ScreenUpdating = False

in your code before you show the userform. Set it to True before showing
the userform.

 

[Ron Dahl]

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

 

[Ivan F Moala]

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

 

[Ron Dahl]

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