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

 

[Oscar Cronquist]

You could perhaps use event code that runs the macro whenever new values are added?

Here is a basic example:
https://www.excel-easy.com/vba/events.html