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
