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 |
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