Application.ontime - Less than 1 second

[kgkev]

Application.OnTime Now() + (TimeValue("00:00:01") / 2), "AutoRecalcWorkbook"

I expected this to recalc every half second. but it seems to be recalcing every 100th of a second.

Changing it to


Application.OnTime Now() + (TimeValue("00:00:01") / 10), "AutoRecalcWorkbook"
or
Application.OnTime Now() + (TimeValue("00:00:01") / 100), "AutoRecalcWorkbook"

has no effect.

Why is this??

 

[Andrew Poulsom]

I would guess that fractions of a second are ignored, so the procedure is run immediately.

 

[RoryA]

I don't believe OnTime accepts that level of precision. (How are you determining that 1/100th of a second interval is being used incidentally?)
If you really need to make your workbook unusable, you can use the VBA timer in a loop (or just use Sleep) or the Windows API timer.