Thread: Userform.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Userform.

That should solve the problem. This problem is usually caused by
ScreenUpdating being set to false.

--
Regards,
Tom Ogilvy

"Bill" wrote in message
ink.net...
Hello,
I have the code given below to show a userform. When the userform comes
up, I can select and move it around the screen. But it keeps its image at
each location, so it is like there are hundreds of userforms on the screen
if I keep moving it around. I thought turning the screen updating to true
would prevent that. Any thoughts?

Application.ScreenUpdating = True
CHUpdate.Show
CHUpdate.Hide
Application.ScreenUpdating = False

Thanks,

Bill