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

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)