VBA / Excel question - progress indicator control?

  • Thread starter Thread starter Enigman O'Maly
  • Start date Start date
E

Enigman O'Maly

I'm setting up web inquiries in a spreadsheet with VBA, and they take a
considerable length of time. The Excel hourglass appears until they're done,
but it would be cool if I could put in a progress bar to give an idea of
remaining time before completion. Unfortunately, there doesn't seem to be a
native one in Excel. Does anyone know of a freeware or shareware version I
could doodle around with?

Thanks in advance...
 
There arei2 progress bar controls included with VBA.
Click on the More Controls icon in the on the Control Tool
box. Then pick the one you want from the list and drag it
to your sheet of form.
 
Chip Pearson has a good one on his site. Check out:

http://www.cpearson.com/excel/Progress.htm

Alternatively, you could use the status bar to display
messages relating to the progress of your procedure. For
example, if you have a variable called PercentComplete
(which represents what the name implies) put the following
line in your code to display a message on the status bar:

Application.StatusBar = Format(PercentComplete, "#.##%")
& " done"

At the end of your procedure, you need to reset the status
bar with the following line:

Application.StatusBar = False

Hope this helps,
Ryan
 
Back
Top