help with generating a progress bar in VBA

[davetherave2]

I currently have built a system that searches for a particular piece of text on the various webpages on the company intranet now this system has been built using VBA in excel. Simply because I don't have access to the webservers so I have built a delay into the system while it loads the pages now I need to generate a progress bar so that it gives some indication that the system is still operating and a estimated time till completion. Currently I am just calculating an estimated time and putting it in the titlebar but I want it to be a little flashier.

So anyone done something similar or know any good places for code snippets that I can view and then see how it is done.

Cheers in advance.

 

[davetherave2]

ok not to worry I figured it out by using the progress bar control.