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

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

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.

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

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

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.

Hi bezdid,

Here's one way you could do it:

Please Login or Register  to view this content.

Regards,

Robert

thank you both, JoeFoot & Trebor76

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

Thanks,

Robert