title: How can I create a progress bar in Excel VBA?
body: <p>I'm doing an Excel app that needs a lot data updating from a database, so it takes time. I want to make a progress bar in a userform and it pops up when the data is updating. The bar I want is just a little blue bar moves right and left and repeats till the update is done, no percentage needed.</p>
  <p>I know I should use the <code>progressbar</code> control, but I tried for sometime, but can't make it.</p>
  <p>My problem is with the <code>progressbar</code> control, I can't see the bar 'progress'. It just completes when the form pops up. I use a loop and <code>DoEvent</code> but that isn't working. Plus, I want the process to run repeatedly, not just one time.</p>