ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Timer code (https://www.excelbanter.com/excel-programming/348191-timer-code.html)

pmguerra

Timer code
 

Hi.

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

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

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

Thank you for your help

--
pmguerr
-----------------------------------------------------------------------
pmguerra's Profile: http://www.excelforum.com/member.php...fo&userid=1498
View this thread: http://www.excelforum.com/showthread.php?threadid=49374


Philip

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




All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com