Excel Userform forcing label update before continuing sub
<p><a href="https://i.stack.imgur.com/PnVEo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PnVEo.png" alt="Ready indicator"></a></p>

<p>I have a sub in a spreadsheet to remove individual line items. Because it takes a few seconds to process, I'd like to have a little Ready indicator.</p>

<p>At the moment I've got a small label (see above) called <code>Lab_Indic</code>.</p>

<p>When the user clicks remove, it runs the <code>_Click</code> sub, which opens with this:</p>

<pre><code>With Lab_Indic
    .BackColor = &amp;HFF&amp;
    .Caption = "WORKING"
End With
</code></pre>

<p>...and closes with this:</p>

<p>With Lab_Indic
    .BackColor = &amp;H8000&amp;
    .Caption = "READY"
End With</p>

<p>But the initial "Working" change only seems to happen if I step through; if I run it normally, it seems to skip past it.</p>

<p>Is there any way to force it to update the label before continuing with the rest? <code>DoEvents</code> sounds like it might do the job, but some sources I've looked at suggest that there might be a downside to that approach.</p>