#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stopping a Timer / Running a timer simultaneously on Excel Paul23 Excel Discussion (Misc queries) 1 March 10th 06 12:08 PM
A VB code for creating count down timer / stopwatch... sanskar_d Excel Programming 2 June 17th 05 11:46 AM
VBA Code help - first timer Poots Excel Programming 2 June 9th 05 07:30 PM
timer dadad Excel Programming 5 December 1st 04 01:46 AM
How to code a timer to trigger a sub-routine ? Joseph[_10_] Excel Programming 1 December 18th 03 12:48 PM


All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"