MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Timer


Posted by Neta on January 03, 2002 12:42 AM

Hi,

I am developing an application Using Excel VBA, and I need to use a timer to show the time elapsed from the begining of a Macro run to the end.

Can you help me using the IeTimer or anything else ?

Thanks a lot,


Posted by Jacob on January 03, 2002 12:52 AM

Hi

You can put this code in
Start = Timer
Application.StatusBar = Timer - Start

if you have a Do loop or for next put the application.statusbar in the loop otherwise you can place the code several times throughout the code. Is this what you are looking for?

Jacob

Posted by Joe Was on January 03, 2002 8:27 AM

Go to J-Walk's site he has a "Progress Bar" that give the user a display like a loading indicator maping the macro's execution. A working example and code with a form picture is at:

j-walk.com/ss/excel/tips/tip34.htm

JSW