Sorry, but you haven't. A Timer control in Classic VB is a control (much like a TextBox) added to a form. It has an 'Interval' property which runs code in the Event Handler for the control every time it fires.used time controls in VBA
In VBA there is a Timer object, not the same thing. You can store the value of the Timer and, later, compare with the current Timer value to see how long a procedure took to run, but there in no 'repeat' facility for the Timer Object - you have to use the OnTime statement to run a procedure at a particular time and then set another OnTime in that procedure to run again...
Splitting hairs, perhaps, but the Timer control would be very useful in VBA.
Bookmarks