Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 3rd, 2009, 06:31 AM
Registered User
 
Join Date: Sep 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default accuracy of Now+timevalue("00:00:01")

Hello,

In my VBA code i use the following instruction

application.ontime Now+timevalue("00:00:01") , "NewTaskToDo"

My question is about the time NewTaskToDo will start.
Roughly, it will start in 1 second.
But if we look exactly, it will start randomly between now and now+1sec

Indeed "Now" is the current time rounded down to the previous second.

I would like to get more accuracy with the starttime of my NewTaskToDo.

Is it possible to get an accuracy/precision of less than 1 sec ? (in millisec?)

Thks
Gwenael
 
Old September 3rd, 2009, 07:49 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi

Can you check if the following post is helpful?

http://vbadud.blogspot.com/2008/10/e...nds-using.html

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Code not going as planned: "icicle" vs "savedinstancestate" joopthecat BOOK: Professional Android Application Development ISBN: 978-0-470-34471-2 3 May 3rd, 2009 03:09 PM
Timer stops counting backwards at 00:01 larry Wrox Book Feedback 1 October 28th, 2003 10:42 AM
Format rounding figure : 1235.00 => 1200.00 Jane SQL Language 1 June 27th, 2003 02:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.