Multiple images of dragged userforms

[donbowyer]

Excel 2003 SP3 on Win XP Home
I have made many userforms simple & complex. They all work fine but seem to
have a common fault. When dragged (moved) they leave multiple images of
themselves behind. How do I stop this
--
donwb

[Norman Jones]

Hi Don,

Do you have ScreenUpdating set to false?

Make sure that ScreenUpdating is set to true when the UserForm is displayed.

---
Regards,
Norman



"donbowyer" <[email protected]> wrote in message
news:[email protected]...
> Excel 2003 SP3 on Win XP Home
> I have made many userforms simple & complex. They all work fine but seem
> to
> have a common fault. When dragged (moved) they leave multiple images of
> themselves behind. How do I stop this
> --
> donwb

[Tom Ogilvy]

This happens if you have used the command

Application.ScreenUpdating = False

Set it back to True before showing your userform

--
Regards,
Tom Ogilvy


"donbowyer" <[email protected]> wrote in message
news:[email protected]...
> Excel 2003 SP3 on Win XP Home
> I have made many userforms simple & complex. They all work fine but seem
to
> have a common fault. When dragged (moved) they leave multiple images of
> themselves behind. How do I stop this
> --
> donwb

[donbowyer]

Many thanks Tom & Norman.
You'd think that at least on one I might not have set updating to false. But
I did'nt and your suh=ggestion solves the problem.
Thanks again

--
donwb


"donbowyer" wrote:

> Excel 2003 SP3 on Win XP Home
> I have made many userforms simple & complex. They all work fine but seem to
> have a common fault. When dragged (moved) they leave multiple images of
> themselves behind. How do I stop this
> --
> donwb