Re: Userform - On movement leaves a trail.
- From: Matts <Matts@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 21 Oct 2008 06:50:01 -0700
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" <Matts@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE78B6E1-F8AB-40A4-A94C-DA6829A798B5@xxxxxxxxxxxxxxxx
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
- References:
- Userform - On movement leaves a trail.
- From: Matts
- Re: Userform - On movement leaves a trail.
- From: Peter T
- Userform - On movement leaves a trail.
- Prev by Date: Populate a formula with macro
- Next by Date: Issue about send email through lotus notes
- Previous by thread: Re: Userform - On movement leaves a trail.
- Next by thread: Populate a formula with macro
- Index(es):
Relevant Pages
|
