Userform Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 20 Jan 2006 16:46 GMT

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

Reply to this Message

Andy Pope - 20 Jan 2006 16:52 GMT

Hi,

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

Cheers
Andy

> Hello,
> I have several user form. With one, when it appears on the screen, you can
[quoted text clipped - 13 lines]
>
> Bill

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Bill - 20 Jan 2006 19:50 GMT

Yes. Is that an issue?

> Hi,
>
[quoted text clipped - 21 lines]
>>
>> Bill

Reply to this Message

Andy Pope - 21 Jan 2006 14:27 GMT

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?
>
[quoted text clipped - 23 lines]
>>>
>>>Bill

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message