Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • 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
ssmith94015
Asked:
ssmith94015
  • 2
1 Solution
 
Rory ArchibaldCommented:
Use:
formname.Repaint
assuming you have a modeless form.
0
 
ssmith94015Author 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
 
ssmith94015Author Commented:
Works like a charm!  Thank you.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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