Userform Issue

[Bill]

Hello,
I have several user form. With one, when it appears on the screen, you can
select and move it around and have many, many images of it on the screen. I
use the following for all forms:

application.screenupdating = true
load userform
userform.show
userform.hide
unload userform
application.screenupdating = false

I thought the screenupdating = true would prevent that. Any ideas?

Thanks,

Bill

 

[Andy Pope]

Hi,

Are you selecting or activating any cells on a hidden worksheet once
that userform is loaded?

Cheers
Andy

 

[Bill]

Yes. Is that an issue?

Hi,

Are you selecting or activating any cells on a hidden worksheet once that
userform is loaded?

Cheers
Andy

 

[Andy Pope]

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.

Cheers
Andy

Yes. Is that an issue?