Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
A VB code for creating count down timer / stopwatch... | Excel Programming | |||
VBA Code help - first timer | Excel Programming | |||
timer | Excel Programming | |||
How to code a timer to trigger a sub-routine ? | Excel Programming |