Excel status loader/counter?

Hot Topic

Change a formula in vba code, How do you
Changing Character Length Setting for a Memo
Get Excel Sheet Names
Setting a global variable and referring to it from a private sub routine?
command line parameters to VBA in PPT?
Can't get picture on desktop
Custom Format Data inside a Cell
Excel Chart: How to change chart data source formula when object "Series.Formula" is too short?
DOS Command Question
MODI and automated printing without manual intervention

Microsoft ISV

Adding a date from a specific cell into the DateAdd function
Place a CR in normal Text Box via vba
Using Inputbox to detect a worksheet
Adding a command button to the toolbar or menu bar in Excel?
How do connect an Excel file from Remote Server
Dynamick picklist in MS CRM 3.0
Can you tell me why Int(1.4 * 100) = 139
ADO Recordsets
personalized command bar disappears when minimizing excel
Adding data in one column based on another column using VBA

Excel status loader/counter?

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

Answer this question

Excel status loader/counter?

elixic
Many Thanks Andy - great selection there...
sachin303
Progress meter is a term often used.

Here is a collection of graphical and statusbar examples.
http://www.andypope.info/vba/pmeter.htm
Excel status loader/counter?

Answer this question