label with continually updated time

[mark kubicki]

i'd like to but a label (?) on a user form which shows the current amount of
time lapsed
(ex: now, it might say: 1:00:00; and in 2 minutes, it would have updated
itself to say: 1:02:00; in three -1/2 minutes: 1:03:30...)

i'm gettting stuck in that i can't figue out how to have the time
continually update itself:

thanks in advance
mark

 

[Bob Phillips]

Mark,

I have an example workbook that uses the windows timer. It has a worksheet
example, but could be easily modified to a form.
Mail me if you want a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Robin Hammond]

Mark,

I didn't see the original post, but as an alternative you could have a look
at the link below for an example that would suit your purposes using an
activex implementation of the VB timer control.

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

Robin Hammond
www.enhanceddatasystems.com