<div>
THX! &nbsp;ha ya, you're just too awesome at this program
</div>


THX!  ha ya, you're just too awesome at this program

<div>
<div class="content wysiwyg-content">
how do I refresh a label that is inside a processing loop?<br />
<br />
<br />
For row_count = 15 To Sheets(&quot;Bidresults&quot;).Range<wbr />(&quot;a15&quot;).En<wbr />d(xlDown).<wbr />Row<br />
Sheets(&quot;scrape&quot;).Cells(row<wbr />_count, 1).Value = Sheets(&quot;Bidresults&quot;).Cells<wbr />(row_count<wbr />, ColumnNames(1, 2)).Value<br />
Sheets(&quot;scrape&quot;).Cells(row<wbr />_count, 2).Value = Sheets(&quot;Bidresults&quot;).Cells<wbr />(row_count<wbr />, ColumnNames(2, 2)).Value<br />
Label1.Caption = &quot;Scraping &quot;&nbsp;&amp; row_count &amp;&nbsp;&quot; of &quot;&nbsp;&amp; Sheets(&quot;Bidresults&quot;).Range<wbr />(&quot;a15&quot;).En<wbr />d(xlDown).<wbr />Row<br />
Next<br />
<br />
<br />
Label1 should display an active count each time through the loop, but it shows nothing until the last iteration. &nbsp;VB.net uses a &quot;refresh&quot; property. &nbsp;How can I do this in excel?
</div>
</div>


how do I refresh a label that is inside a processing loop?


For row_count = 15 To Sheets("Bidresults").Range("a15").End(xlDown).Row
Sheets("scrape").Cells(row_count, 1).Value = Sheets("Bidresults").Cells(row_count, ColumnNames(1, 2)).Value
Sheets("scrape").Cells(row_count, 2).Value = Sheets("Bidresults").Cells(row_count, ColumnNames(2, 2)).Value
Label1.Caption = "Scraping " & row_count & " of " & Sheets("Bidresults").Range("a15").End(xlDown).Row
Next


Label1 should display an active count each time through the loop, but it shows nothing until the last iteration.  VB.net uses a "refresh" property.  How can I do this in excel?

how do I refresh a VB Label?

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