Scott Boyd


Hey,

Not quite sure how to word this but what i'm looking for is like some sort of preloader or egg timer style graphic or percentage counter to display when my function is running to indicate to users the current progress.  The function i'm running takes up to 3 mins to calculate so wanted to be able to show users that the program hasn't froze etc.

[EDIT] Sorry just to update, i now know how to show the egg timer etc using application.cursor=XLwait but i would be interested to know if a percentage bar can be displayed   Thanks

Any ideas




Re: Excel status loader/counter?

Andy Pope


Progress meter is a term often used.

Here is a collection of graphical and statusbar examples.
http://www.andypope.info/vba/pmeter.htm






Re: Excel status loader/counter?

Scott Boyd

Many Thanks Andy - great selection there...