When using a timer control, it is important to prevent re-entry.This occurs when the processing in the _Timer event takes long enough to still be executing when the next _Timer event fires. It is even possible for the execution of the second timer event to pass up that of the first. Depending on what the code does, re-entry can cause all sorts of hard-to-trace problems.
A simple solution is to disable the timer control during the timer event handler:
Private Sub Timer1_Timer() Timer1.Enabled = False 'rest of code goes here Timer1.Enabled = True End Sub
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
