Create a time delay at end of procedure that will then call on next procedure

**Clay Shooter** · 03-31-2013, 04:19 AM

I have a workbook generated and formatted using VBA that displays names and scores from another workbook to display a scoreboard. Using rows.hidden procedures I can filter the data to show the various classes of the scores. All good so far, but after filtering the data I need to create a delay before the procedure calls the next macro that will refilter the classes. The workbook is displayed on a second monitor, while data is updated in the original workbook. Application.Wait will not work as it freezes excel while waiting. What other method could be used?

**HaHoBe** · 03-31-2013, 04:26 AM

Hi, Clay Shooter,

have you tried Application.OnTime to call the macro at a given time if the amendment of DoEvents can´t help with Application.Wait?

Ciao,
Holger

**Clay Shooter** · 03-31-2013, 05:56 AM

Hi HaHoBe,
Yes I tried Application.OnTime but I could not get variable values for the start time to work, however after your suggestion I rechecked and discovered that I had a remnant code that was calling itself circularly - thus always extending the OnTime value. Sometimes it pays to think about things carefully before asking questions. Thanks for your response.