running timer
 

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

running timer
 

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

-----Original Message-----
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
.

running timer
 

this excel.programming site or another one?

"JbL" wrote:

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

running timer
 

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

http://www.enhanceddatasystems.com/E...ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com

"JbL" wrote in message
...
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