Thread: Userform.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default Userform.

Here is a post from Andy Pope that MIGHT help

Activating cells on a hidden sheet whilst the userform is displayed will
cause ghosting if you move the userform.

I suggest you confirm this by simply making the sheet visible and then
move your userform around. If the problem goes away you will need to
alter your code. You can still reference and use the cells on the hidden
sheet just not activate them. Most tasks do not require you to activate
the cells in order to manipulate them.


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"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