time procedures run
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Time for procedures to run

resolvedResolved · Low Priority · Version 2007

replyReply Tue 25 Nov 2008, 16:20Delegate 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?

For upcoming training course dates see: Pricing & availability

replyReply Thu 27 Nov 2008, 10:46Trainer 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.

 

Please browse our web site to find out more about
excel-training-course and other Microsoft training courses.

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard