A stopwatch in a userform

[Pierre Archambault]

Hi,

I am using Windows 2000 Prof. and Excel 2000.

I need to put a stopwatch in a userform. It will display the time elapsed
(hh:mm:ss), there wil be a button to start de stopwatch another to pause and
a third to stop it. The display must be updated continually while the user
is still working in the userform.

I found a snippet of code on the Internet that would probably do the job but
I need to have "ietimer.ocx" on my machine and I don't have it.

Whete can I find that file ? Is there another way to achieve that goal
without using that ocx

Thanks

Pierre

 

[Jerry N]

Pierre
You can download this ActiveX control at:
http://activex.microsoft.com/controls/iexplorer/x86/ietimer.cab
Place the Ietimer.ocx control in your C:\Windows\System32 directory then
install it through VBA; go to Tools/References, browse for Ietimer.ocx in
your Windows\System 32 directory. Select it, click OK.
Next, activate your timer userform,then go to Tools/ Additional Controls.
Scroll down to "Timer Object" and sselect it to place the ActiveX control in
your toolbox. If you want the control to always be in your toolbox, go to
Start/Run and then type: regsvr32.exe ietimer.ocx
Regards, Jerry

 

[Robin Hammond]

There's an alternative timer and demo of something similar to what you want
to do here:

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

Robin Hammond
www.enhanceddatasystems.com