<div>
Works like a charm! &nbsp;Thanks!
</div>


<div>
You're welcome and I'm glad I was able to help.<br />
<br />
Marty - MVP 2009 to 2012
</div>


You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2012

<div>
<div class="content wysiwyg-content">
I have an excel workbook with a lot of custom code going on in it and it takes a while to calculate (5-7 seconds)<br />
<br />
Because of this, instead of leaving calculation set to Automatic, I manage it with VBA as the user clicks around and does different things (toggling calculation on and off, and recalculating programmatically as necessary). &nbsp;All of this works fine.<br />
<br />
As a nice-to-have, I'd like to display a form with a label on it that says &quot;Calculating. &nbsp;Please wait&quot; while the calc occurs so the user doesn't just think their computer is broken. &nbsp;Problem is, when I display such a form via code, the rest of the code doesn't complete until I close the form manually again (clicking on the X button). &nbsp;Is there a way around this?<br />
<br />
In other words: &nbsp;is there a way to make the form run asynchronously from the code that displayed it?<br />
<br />
AR
</div>
</div>


I have an excel workbook with a lot of custom code going on in it and it takes a while to calculate (5-7 seconds)

Because of this, instead of leaving calculation set to Automatic, I manage it with VBA as the user clicks around and does different things (toggling calculation on and off, and recalculating programmatically as necessary).  All of this works fine.

As a nice-to-have, I'd like to display a form with a label on it that says "Calculating.  Please wait" while the calc occurs so the user doesn't just think their computer is broken.  Problem is, when I display such a form via code, the rest of the code doesn't complete until I close the form manually again (clicking on the X button).  Is there a way around this?

In other words:  is there a way to make the form run asynchronously from the code that displayed it?

AR

Display Excel Form while VBA code runs

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.