Application.OnTime.... Calculate every 200 milliseconds. Is there a way?

[mtheriault2000]

Hello

The function Application.OnTime could be use to refresh or recalculate a cell with the minimal interval of 1 second. Is there a way to have the function using a 200 milliseconds interval?

Martin

 

[mtheriault2000]

I am unfamiliar wit RTD or at least am not thinking of what it is an acronym for. Logging out, and may be missing something, but why not store the return in a variable instead of the cell?

Have a good day,

Mark

RTD stand for Real Time Data.

I want to have the value in real time, meaning being updated has a new one is available. Has I understand, the RTD is managed via the operating system and do wait for Excel to be idle before sending the value. This concept I suppose do insure that Excel will be up and running without flaws.

I still don't understand how to use it do.

Martin

 

[joeu2004]

PS....

Apparently, Windows timers side-step the mechanism that ensures that only one of the Excel and VBA threads runs at a time. And that might explain why the typical OnTime interval is so much longer.

Not really. 230 ms is an eternity on modern CPUs. I am not familiar with Windows and Excel/VBA internals, so I am reluctant to speculate further.