Timer code

[pmguerra]

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.

[Philip]

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