Tuesday, November 28, 2006

A Progress Bar

http://blog.livedoor.jp/andrewe/#top

I did quite a lot of programming work last week but took a little time off to have some fun.

Here is a progress bar made from a userform with no title bar.



And a link to see how it works.

A couple of things that may be of interest.

The code to remove the title bar comes Colo's Excel Junk Room who has quite a lot of other useful vba tips that involve userforms and other things.

Andy Pope of AJP Excel Information has some very interesting examples of progress bars in his collection of userform downloads and a lot of other great stuff to look at as well.

Colo's Excel Junk Room

AJP Excel Information

Well worth the visit ;-)

No comments: