Excel – How to create a status dialog box in Excel

excelvba

I have created a database report generator in Excel. I am trying to create a dialog box that displays status information as the program runs.

When I generate the report, although the dialog box appears, I cannot refresh/update the information it displays. Most of the time, the dialog box only partially appears. I have tried using the .repaint method, but I still get the same results. I only see the complete dialog box, after the report is generated.

Best Solution

Try adding a DoEvents call in your loop. That should allow the form to repaint & accept other requests.