Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel VBA
|
|
|
The UK's most regular 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 VBA
Resolved · Urgent Priority · Version 2003
Reply Fri 12 Dec 2008, 16:51Delegate Christian said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Wed 17 Dec 2008, 10:26Delegate Christian said...
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
Reply Mon 19 Jan 2009, 15:25Delegate Christian said...
RE: Excel VBA
Thanks Stephen.
Best regards,
Christian
Wed 14 Jan 2009: Automatically marked as resolved.
|