Link to home
Create AccountLog in
Avatar of Sandra Smith
Sandra SmithFlag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Sandra Smith

ASKER

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.
Works like a charm!  Thank you.