Excel userform 2

[BobHudson]

I have created a userform and I noticed that if I move it on the screen that I see a trail of where the userform was (Much like the mouse trails option for LCD screens, except the trail does not go away). I was wondering what I had turned on to get this to happen.

Thanks for any suggestions.

Bob Hudson

 

[rmikesmith]

Bob,

Somewhere in your code, prior to displaying the Userform, you have turned of screen updating (

Application.ScreenUpdating = False

). Make sure screen updating is on (=True) before displaying Userforms or MsgBox. Typically, you would turn screen updating off while making changes to a sheet, then restore.


HTH
Mike