User Form creating shadow images when moved?

[Don Wiss]

When I first show a User Form I can move it around. But if the code has
acted on the workbook, like importing sheets, then when moving it around it
leaves behind an image of where it was before. Can this be fixed?

Don <www.donwiss.com> (e-mail link at home page bottom).

 

[JLGWhiz]

Only the Shadow knows. <lol>

sounds like you might have a system problem. I have never run across that
as a programming defect.

 

[Dave Peterson]

Turn on screenupdating before you show the userform.

Turn off screenupdating (if you want) after the form is hidden/unloaded.

 

[scott]

What version of Excel are you using?
I have seen this in Excel when system resources were too low
and thus the screen is unable to refresh correctly..
I especially saw this with older versions or a computer with limited
resources to begin with.
As Dave suggests Application.ScreenUpdating usage often helps.

Scott

 

[Don Wiss]

What version of Excel are you using?
2002

I have seen this in Excel when system resources were too low
and thus the screen is unable to refresh correctly..
I especially saw this with older versions or a computer with limited
resources to begin with.

I doubt that resources are low. This happens on any computer.

As Dave suggests Application.ScreenUpdating usage often helps.

I always turn Application.ScreenUpdating off before making any changes to
the spreadsheet. I don't bother turning it back on at the end of the macro,
as closing the macro does this. So apparently it is still off when control
is returned to the User Form. This is at work, so I can't test it out, but
this makes sense.

Don <www.donwiss.com> (e-mail link at home page bottom).