label with continually updated time
 

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

label with continually updated time
 

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)

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

label with continually updated time
 

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/E...ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com

"Bob Phillips" wrote in message
...
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)

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