Stop running macro when time value in a cell reached or exceed

[bezbid]

I have a running macro to get live data from a real time data server, how to auto stop the macro from running if cell A10 time value reached/exceed a set value 14:00:00

ty for help

[JoeFoot]

Please Login or Register  to view this content.

that's if you want exactly equal to 14

For bigger or equal use this:

Please Login or Register  to view this content.

[bezbid]

how is the code if time is 14：45：00

Thank you joeFoot

[JoeFoot]

the 2nd instruction will stop the macro whenever the time is 14:00:00 or higher so it will work for 14:45:00

[bezbid]

OK, how about 13:35:00, how would your 2nd code be

can the first code be use like this,

Please Login or Register  to view this content.

thank you

[JoeFoot]

the code only checks for the status of the first 2 digits (in this case 14)

If you want it to stop after 13:35:00 you would need to introduce also a condition to check the 4 and 5 value of the string:

Please Login or Register  to view this content.

[Trebor76]

Hi bezdid,

Here's one way you could do it:

Please Login or Register  to view this content.

Regards,

Robert

[bezbid]

thank you both, JoeFoot & Trebor76

[Trebor76]

thank you both, JoeFoot & Trebor76

You're welcome. If you could mark the thread as solved it would be appreciated.

Thanks,

Robert