Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

**ansheng** · 02-02-2019, 03:51 PM

I have a code to sample variable value of cell D1 at every second

Please Login or Register  to view this content.

Sampling of cell D1 needs to be done 24x7. While code runs perfectly upto 23:59:59 hrs but after that Timer stops. I have checked it's value reaches to 86397. I tried to reset Timer but VBA gives error that Read Only property can not be changed.
I tried s = Now + TimeValue("00:00:01") also instead of Timer function but that does not samples value of D1 exactly at 1 second interval. So, I want to use Timer.
For that I want to know how to reset Timer, if possible?
Or any other way so that sampling of values of D1 keeps continue after 23:59:59 hrs.

Thanks.

**JLGWhiz** · 02-02-2019, 04:16 PM

If I recall correctly, you were using another macro to call the one in Post #1. that is the one you need to be working with. This one only provides the timing interval, not the start and stop.

**mjr veverka** · 02-02-2019, 04:16 PM

Try:

Please Login or Register  to view this content.

**JLGWhiz** · 02-02-2019, 04:26 PM

Please Login or Register  to view this content.

This might work also.

**ansheng** · 02-03-2019, 06:37 AM

Thank you very much, porucha vevrku. Now Code works even after 23:59:59 hrs. Thanks for your quick reply.

**ansheng** · 02-03-2019, 06:41 AM

Originally Posted by JLGWhiz

Please Login or Register  to view this content.

This might work also.

JLGWhiz, This is giving Compile error: Sub or Function not defined. But thanks for your effort & quick reply.

**mjr veverka** · 02-03-2019, 07:36 AM

What if all cells in the column 'B' are used and there is no room for further entries (12.1 days), of course, if you change "For k = 1 To 100" drastically ?

**JLGWhiz** · 02-03-2019, 09:53 AM

Originally Posted by ansheng

JLGWhiz, This is giving Compile error: Sub or Function not defined. But thanks for your effort & quick reply.

OK, apparently you did away with the 'Repeat' macro.
Regards, JLG

**ansheng** · 02-03-2019, 01:19 PM

Originally Posted by porucha vevrku

What if all cells in the column 'B' are used and there is no room for further entries (12.1 days), of course, if you change "For k = 1 To 100" drastically ?

Actually this code is small part of a large code. I want to sample D1 values 100 times actually 900 times in column B but after that all these 900 cells clears & process of sampling begins again 900 times starting from B1 to B900. This code is inside infinite loop. I need cells only from B1 to B900.

**ansheng** · 02-03-2019, 01:29 PM

Originally Posted by JLGWhiz

OK, apparently you did away with the 'Repeat' macro.
Regards, JLG

Yes, now the actual code has changed significantly from that in Post#1. I have modified the code as per my increased requirements.

**mjr veverka** · 02-03-2019, 03:47 PM

To avoid complications with 'Timer' use api 'timeGetTime' or 'GetTickCount'.

**ansheng** · 02-04-2019, 10:11 AM

Originally Posted by porucha vevrku

To avoid complications with 'Timer' use api 'timeGetTime' or 'GetTickCount'.

How to use these api's?

**mjr veverka** · 02-04-2019, 06:19 PM

... quite simply and normally ... use forum search ... it will be quite a few ...

... in your case it would look almost the same as with "Timer", e.g.:

Please Login or Register  to view this content.

You have about 49 days to overflow your counter.

**ansheng** · 02-26-2019, 11:56 AM

Originally Posted by porucha vevrku

Try:

Please Login or Register  to view this content.

There is a cell in which time comes from time.is site (web) only 1 time (first of all) by pressing Ctrl+Alt+F5 before starting the macro. Then 00:00:01 gets added every time ' Timer ' runs to that cell and hence clock runs. But I'm unable to get exact 1 second in 's = Timer +1 ' , so I need to adjust value 1 to 0.94 to 0.97 every time I run the macro to get exactly 1 second difference as compared to GPS time. In addition to this after some time clock (time) lags behind or lead ahead 1 second then 2 seconds then 3 seconds & so on than actual GPS time. So I need to adjust 's = Timer +1 ' again & again.
So why is there a variable second difference? & How can it be made exact as GPS time? Or is there any method to fetch GPS time directly every second in this macro sheet?

Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

LinkBack

Thread Tools

Rate This Thread

Display

Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Re: Need Help to Reset Timer function in Excel VBA after 23:59:59 hrs

Thread Information

Users Browsing this Thread

Similar Threads

Create running stopwatch/timer with 1 button (start/stop). No reset button.

Need help with timer/stopwatch...how to change activex button color...how to reset form

Displaying a unique countdown timer with Start/Stop/Reset buttons on multiple lines

Need Countdown Timer in Excel with automatic reset to pre-determined value

[SOLVED] formula for count down stop watch with reset timer

Excel Timer function

How can I reset a timer?

Bookmarks

Bookmarks

Posting Permissions