ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   userform dragging problem (https://www.excelbanter.com/excel-programming/419744-userform-dragging-problem.html)

yspin

userform dragging problem
 
Hi,

I have an issues that when the user drags the userform is spreads
through the screen like a memory problme.

I tried application.screenupdate= false and true in the begining of
the code and the end, it didnt help.

Where do i need to put it? i tried in the userform initialize code.
I heard that calling hidden sheets in the code will also cause this.

What is the solution please?

Mike H

userform dragging problem
 
Hi,

In trying you've probably ended up with screenupdating switched off. the
correct syntax is

Application.ScreenUpdating = True

not screenupdate as in your post.

Mike



"yspin" wrote:

Hi,

I have an issues that when the user drags the userform is spreads
through the screen like a memory problme.

I tried application.screenupdate= false and true in the begining of
the code and the end, it didnt help.

Where do i need to put it? i tried in the userform initialize code.
I heard that calling hidden sheets in the code will also cause this.

What is the solution please?



All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com