Loading Bar
G'day there Justin, Darlove, and all others,
take a look at 'Microsoft Excel 2000 Power Programming with VBA' by
John Walkenbach or its later versions by the same author (you can find
it on the Web as a pdf file ;-). He gives very cute pieces of code that
will do all the black work for you and you will be - I promise - very,
very happy with the final product you'll arrive at. You'll get a very
professional-looking loading status bar (fully customizable, of
course). I would give you the code but unfortunatelly it requires to
build a (very simple, indeed) form, so it would take too much to
explain in here.
I can thoroughly recommend John Walkenbach's books. I have the
2003 iteration of the above title right here alongside me atop a dead
'pooter case. It's a well worn tome.
Be that as it may, the above is 100% correct. The code provided is
spot on, extremely simple to adapt to requirements and works marvelously
well. My last project included a simple call to the appropriate
subroutine as my main loop progressed. The provided me with a very
professional looking progress bar that did all the right things. Quite
impressed I was. I'm now awaiting the world wide acclaim I believe I'm
entitled to in the category of "Magnificent Use of Code Written by
Someone Who Knows Far More About the Subject Than I Do".
It will probably be the easiest and most efficient way to get a
progress bar that you will find anywhere.
See ya
Ken McLennan
Qld, Australia
|