Userform stopwatch format milliseconds

[Herman]

Hi,

I want to put a stopwatch in a label. What is Format to
display minutes, seconds, and milliseconds?

Thanks in advance,

Herman

 

[David McRitchie]

hh:mm:ss.000

But I think you only get 100ths of seconds.

If you want a something for timing the speed of a macro
you might want to take a look at
http://www.mvps.org/dmcritchie/excel/slowresp.htm#timer

 

[Bob Phillips]

David,

100ths seem to work for me (Excel 2000, XP) in a worksheet cell.

However, when trying to apply it to a label

Label1.Caption = Format(Range("A1"), "hh:mm:ss.000")

shows simply as .000

but

Label1.Caption = Range("A1").Text

shows okay.


--

HTH

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