Thread: Userform.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
kataiwo kataiwo is offline
external usenet poster
 
Posts: 2
Default Userform.

I think the problem is because the form is shown modal by default and because
of this, your code actually stalls at the point you show the form. Showing
the form modeless should solve the problem as below:
myform.show vbmodeless
--
kataiwo


"Tom Ogilvy" wrote:

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