• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Run Multiple Macros At Different Set Time Intervals vba via button to start- button to stop


New Member
Hi everyone, i currently have 5 macros, they refresh my data, macro1 refresh data from sheet1, macro2 refreshes data from sheet2 and so on
untill sheet5, each sheet has its own macro to refresh its own sheets data. So what i need is when macro1 starts, wait one minute before running macro2,
"macro2 finishes", waite one minute before running macro3 ans so on till last macro, then i can start the sequence, or stop it an any time via the buttons.
It is data from the web in excel, i have tried going to table properties but have been unable to refresh all 5 tables at time intervals as explained previously.
Any help here is highly appreciated.