Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Time for procedures to run

Time for procedures to run

ResolvedVersion 2007

Tue 25 Nov 2008, 16:20 Delegate Katy said...

Katy has attended:
Excel VBA Advanced course

Time for procedures to run

Is there a way of having a timer included which will tell the user how long is left for the macro to run?

Thu 27 Nov 2008, 10:46 Trainer Stephen said...

RE: time for procedures to run

Hi Katy

Thanks for your question

It would be very difficult to calculate how long a procedure has to run simply because the code's run would be suspended everytime a message or input box appears.

The remaining elapsed time would be dependent upon how quickly the user responds to these events.

Regards

Stephen

Thu 4 Dec 2008: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips

Time for procedures to run

Time for procedures to run

RE: time for procedures to run

Excel articles

Excel tip:

COUNT function vs COUNTA function