VBA Calculate Pause

Hi everyone I am having a little trouble with a sheet i'm currently working on. Having exhausted what i believe to be every avenue trying to do this without VBA, i've finally had to sucomb to it as i can't see an alternative and i'm no VB expert by any means! This is what i have so far:

Please Login or Register  to view this content.

Basically what i am trying to do is insert a pause, sleep, wait etc. command into my IF statement.

If cell J10 (10, 10) = 1 or 2, pause for 300 milliseconds, then fill cell M10 (10, 13) with the value 3.

I am aware the wait and sleep commands cause excel not to funtion while the command is in use. Ideally i would like everything to perform as usual just that specific cell is paused. I use a program that writes all the data into Excel and it updates every 250ms hence my above effort is under Worksheet_Calculate().

Hello jc0r,

I have added a 250 millisecond delay to your code. This will still process events in the background but delay the macro's execution. It isn't a high accuracy timer but tests on my machine were accurate to within 500 microseconds. The Timer counts the seconds from midnight since Windows was last started. It updates every microsecond.

Please Login or Register  to view this content.

Hello jc0r,

Do mean display the value in a message box or some other way?

Hello jc0r,

Adding another timer loop and setting it for 2 seconds and clearing the cell should work. Try this...

Please Login or Register  to view this content.