Thread: Timer code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Philip Philip is offline
external usenet poster
 
Posts: 156
Default Timer code

Hi,

I don't think you can get milliseconds using the native VBA functions, you
need to
use the API functions for that...

For example, the API 'Sleep' function ...

have a look at CPearsons site he
http://www.cpearson.com/excel/ontime.htm

HTH

Philip
"pmguerra" wrote:


Hi.

I'm new at VBA so please be patient... :)

I've worked out a code for a timer programme. I've used dataserial and
time serial function.

I've managed to record each intermediate time in the correct cell but
it want it to record miliseconds, i.e., ss,000... How can I solve
this?

Thank you for your help.


--
pmguerra
------------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986
View this thread: http://www.excelforum.com/showthread...hreadid=493748