98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel VBA
Excel VBA
Resolved · Urgent Priority · Version 2003
Christian has attended:
Excel Advanced course
Excel VBA
Could you provide more detail on how to add the standard progress bar to a spreadsheet. Very little information on the webpage. Would be interested in an example of how it can be implemented into code (very simple example would be sufficient - just to see how to implement it into a Do Loop. Many thanks in advance and best regards,
Christian
RE: Excel VBA
Hi Christian
Thankyou fpr your question.
Could you please clarify what you mean by standard progress bar.
Are you refering to an indicator showing how complete a task is?
Regards
Stephen
RE: Excel VBA
Hi Stephen,
Many thanks for your response. Yes, that's correct.
Best regards,
Christian
RE: Excel VBA
Hi Christian
Thank you for your question, and the following update.
Creating a procedure that runs a time elapsed bar would be a complex undertaking, perhaps using the Timer Function. You would also need some way to objectively measure progress on a particular task, e.g number of records assessed in a recordset.
Creating such a procedure is beyond the scope of the forum, however it might be possible to download some code from the web that would do this for you. I suggest a google search as a first step.
Regards
Stephen
Wed 14 Jan 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply currency format quickly in ExcelTo quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $ |