title: How can I display a progress bar for a built-in Excel function?
body: <p>I have an Excel table set up with around 40,000 values that need to be sorted via a userform.  For this, I used...</p>
  
  <pre><code>myTable.Sort.SortFields.Add Range(strSortBy), xlSortOnValues, xlDescending, xlSortNormal
  myTable.Sort.Apply
  </code></pre>
  
  <p>...where myTable is the table and strSortBy is the header of the column I want to sort by.</p>
  
  <p>Now, despite Excel's lightning-fast sorting capabilities, with this amount of data it starts taking long enough (several seconds) that I'd like to provide the user with some kind of progress feedback.  I've made several userform progress-bars in Excel, but since Sort is a <strong>built-in</strong> Excel function, I can't see any obvious ways to show or determine the percentage completed.</p>
  
  <p>Is this a lost cause?  Or is there some way to determine the progress of built-in functions?</p>
  
  <p>Any help is greatly appreciated.</p>