title: Refresh UserForm without refreshing worksheet
body: <p>While working with Excel, I have many times faced the problem with Screen Refreshing. </p>
  
  <p>Most of the time, in order to speed up VBA, programmers will use <code>Application.ScreenUpdating = False</code>. This will temporarily (until cancelled) stop screen refreshing. Unfortunately, there are cases, such as implementing progress bar, when you actually <strong>want</strong> to show some progress to the user. The problem is that the already mentioned command has stopped all screen refreshing. </p>
  
  <p>This means, that even if on your <code>UserForm</code> you call a command to change a label (e.g. which would state <em>Processing transaction 15 of 250</em>) but you simply cannot get it to display.</p>
  
  <p>What some people do in this case, is to temporarily enable <code>ScreenUpdating</code>, and right away disable it. This procedure is unfortunately unreliable, as if you have some difficult procedure (inserting complex formulas into cells) you are not guaranteed all the time that it will also refresh the label itself. Also the problem with this approach is, that you repaint not only your desired <code>UserForm</code>, but also <code>Worksheet</code> as well, and therefore this 'refresh' slows down your code quite a bit.</p>
  
  <p>How can you refresh <code>UserForm</code> without refreshing the <strong>whole Excel</strong>?</p>