VBA Timer to repeat function

Hi

I have set timer in the attached sample sheet to run every 30 seconds thru VBA but it runs only once

I am not sure what mistake I have done hence seeking help

When you set a timer, it only fires once. If you want it to repeat you have to set it again. In Workbook_Open you set the timer to call recalculate but then recalculate does not reset the timer. It needs the same code as in Workbook_Open to set the timer.

You have some other problems in Workbook_Open:

• You set range_Timer to A1 but then refer to range_Timer.Range("A1"). This will not cause an error but is redundant.
• The value on sheet Timer is already a time value so does not need to be converted to text and then back to time.
• You flow through to your error handler code so it will execute every time, even when there is no error.

Also recalculate should be a Sub, not a Function. It does not return anything.

I have fixed these problems as well.

Please use Report Post only to report a rule violation or other concern that must be reviewed by Moderators. If you wish to respond to a thread post, just click Reply.

Originally Posted by grcshekar

grcshekar has reported a post.

Reason:

Thank you

Post: VBA Timer to repeat function
Forum: Excel Programming / VBA / Macros
Assigned Moderators: Leith Ross, dominicb, Ron Coderre, daddylonglegs, Paul, JBeaucaire, DonkeyOte, zbor, jeffreybrown, 6StringJazzer, alansidman, arlu1201, vlady, Fotis1991, FDibbins

Posted by: 6StringJazzer

Apoloiges instead of post it became report

Thank you it worked