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?
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
assuming you have a modeless form.
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.
ssmith94015Author Commented:
Works like a charm!  Thank you.
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.

All Courses

From novice to tech pro — start learning today.