Add delay into Loop in VBA without locking Excel

[theglitch]

Hi Experts,

I have searched the site and others but I can't seem to find a way to do what I am trying to do.

- I have a Macro that runs another Program and needs to run one by one down the Excel file.
- The Macro runs the file fine, but the Program writes back to Excel values that I need for the next run
- I need the next run to be delayed till the values are written back into the Excel file (I am using a Loop for the repetitive runs)(2 min delay)


I tried application.wait and others but it locks Excel from writing back. I am not sure how to do the While loop in a loop it keeps giving errors. Any help would be greatly appreciated.

Do Until LoopCount = 0

Other Program Stuff

Delay Needed Here (I think)

Loop

MsgBox "All done!"


Exit Sub

[JLGWhiz]

This will delay for a half second. You can use whole or decimal values measured in seconds for your delay times. The DoEvents will allow other events and apps to run while pausing the current macro.

Please Login or Register  to view this content.

[theglitch]

Thank You JLGWhiz That Worked!

[JLGWhiz]

Thank You JLGWhiz That Worked!

You're welcome. Don't forget to click Solved.
regards, JLG