Userform - On movement leaves a trail.
 

Hi,
I've developed an excel aplication which has two basic functionalities &
works usings 2 different userforms (specific for each purpose)

Ist functionality Input record
2nd Functionality View/Edit/Submit record

Question,
While working on the 2nd functionality, when the record is being viewed or
edited, if I try & move the position of the userform, it leaves a trail of
the form (like duplicates) in a wavery format. This is something you will
normally see when a system hangs. HOw do i correct this.

I'm not a VBA professional.
I've simply used a lot of code from samples available on the net.

Apreciate all help.

Regards,
Mathew

Userform - On movement leaves a trail.
 

My guess is you have left app.screenupdating = false

Screenupdating should only be temporarily disabled while changing the
interface, eg writing to cells.

Regards,
Peter T

"Matts" wrote in message
...
Hi,
I've developed an excel aplication which has two basic functionalities &
works usings 2 different userforms (specific for each purpose)

Ist functionality Input record
2nd Functionality View/Edit/Submit record

Question,
While working on the 2nd functionality, when the record is being viewed or
edited, if I try & move the position of the userform, it leaves a trail of
the form (like duplicates) in a wavery format. This is something you will
normally see when a system hangs. HOw do i correct this.

I'm not a VBA professional.
I've simply used a lot of code from samples available on the net.

Apreciate all help.

Regards,
Mathew

Userform - On movement leaves a trail.
 

Works great Peter, Thanks for your advice.

"Peter T" wrote:

My guess is you have left app.screenupdating = false

Screenupdating should only be temporarily disabled while changing the
interface, eg writing to cells.

Regards,
Peter T

"Matts" wrote in message
...
Hi,
I've developed an excel aplication which has two basic functionalities &
works usings 2 different userforms (specific for each purpose)

Ist functionality Input record
2nd Functionality View/Edit/Submit record

Question,
While working on the 2nd functionality, when the record is being viewed or
edited, if I try & move the position of the userform, it leaves a trail of
the form (like duplicates) in a wavery format. This is something you will
normally see when a system hangs. HOw do i correct this.

I'm not a VBA professional.
I've simply used a lot of code from samples available on the net.

Apreciate all help.

Regards,
Mathew