Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
JbL JbL is offline
external usenet poster
 
Posts: 17
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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
.

  #3   Report Post  
Posted to microsoft.public.excel.programming
JbL JbL is offline
external usenet poster
 
Posts: 17
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
timer Steve[_9_] Excel Discussion (Misc queries) 4 January 28th 08 08:10 PM
Timer Vijay Excel Worksheet Functions 1 April 6th 07 11:00 AM
Stopping a Timer / Running a timer simultaneously on Excel Paul23 Excel Discussion (Misc queries) 1 March 10th 06 12:08 PM
Timer Neil Excel Programming 2 May 21st 04 11:30 AM
Running Macro with B/ground Timer Damian Lee Excel Programming 2 February 12th 04 05:37 AM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"