running timer

[Guest]

I have a form that displays the updating actions of many macros that are
running behind the scenes. While all of these files are updated, I am trying
to have a box on the form display the update time in min & seconds
continiously. Right now, I am taking a time stamp of now-startime after each
process and rapainting the form. Any ideas?
Thanks,
jbl

 

[Guest]

hi,
not of the top of my head but this site is all about time
relating to excel. they do have timers. you might find one
to use.
regards

 

[Guest]

this excel.programming site or another one?

 

[Robin Hammond]

This might help. It's identical to the VB timer control for use in Excel.

http://www.enhanceddatasystems.com/ED/Pages/ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com

 

[Stephen Bullen]

Hi JbL,

I have a form that displays the updating actions of many macros that are
running behind the scenes. While all of these files are updated, I am trying
to have a box on the form display the update time in min & seconds
continiously. Right now, I am taking a time stamp of now-startime after each
process and rapainting the form. Any ideas?

I've had a lot of success with Microsoft's IETimer control. Search the Microsoft
web site for it - it's a free download from one of the KB articles.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk