excel vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel VBA

Excel VBA

resolvedResolved · 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

RE: Excel VBA

Thanks Stephen.

Best regards,

Christian

Wed 14 Jan 2009: Automatically marked as resolved.


 

Excel tip:

Apply currency format quickly in Excel

To 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 + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips


Server loaded in 0.08 secs.