How to stop "image trail" of a form?

[Jaymond Flurrie]

First of all, I have absolutely no idea of the correct term for this. I would need some kind of screen updating function to implement this.

So I open Excel, it opens a form like I want. But now when I use the title bar of my form to drag it around, it leaves "trail" about where the form was, like Windows does when something freezes. The result is pretty much the same than when you complete a solitaire game and those cards "jumps" down from their stacks. leaving a trail behind.

The thing I'd like to get would be that the trail is somehow removed. I tried:

Private Sub UserForm_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    Application.ScreenUpdating = False
End Sub

Private Sub UserForm_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    Application.ScreenUpdating = True
End Sub

but this only works when I click the form inside, but not clicking the title bar (which is naturally the critical part, since that's the part used for dragging and dropping).

I could imagine I'm not the first one with this problem.

 

[Jaymond Flurrie]

Hmm... It seems to work every now and then.

 

[Peter_SSs]

Yes, I have had that problem before. The solution was to ensure that ScreenUpdating was ON the whole time the form was displayed?