• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

Suspend Excel VBA to allow form to update

I have a long process that grabs workbooks from out Intranet, copies them into a master file locally and save the local workbook.  There can be from 25 to 138 worksheets downloaded and I hav on the main form a "countdown" lablel that shouldupdate each time one of the intranet worksheets have been copied locally.  It works when I step through the code, but when the code runs, it appreantly is going so fast, the form does not update.  How can I get the form to reflect the information as each worksheet is copied?
0
Sandra Smith
Asked:
Sandra Smith
  • 2
1 Solution
 
Rory ArchibaldCommented:
Use:
formname.Repaint
assuming you have a modeless form.
0
 
Sandra SmithRetiredAuthor Commented:
I assume I should put that just after the line where the form is updated with the current count.  Let me try and will be right back.
0
 
Sandra SmithRetiredAuthor Commented:
Works like a charm!  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now