Fri 17 Apr 2009, 15:53Delegate Anthony said...
Anthony has attended:
PowerPoint Intermediate Advanced course
Excel VBA Intro Intermediate course
Project Intro Intermediate course
Upgrade to Office 2007 course
Excel VBA
How do I insert a timer onto a form and check for a variable change every 60 secs or so?
Mon 20 Apr 2009, 09:44Trainer Anthony said...
RE: Excel VBA
The Timer control is an ActiveX control and does not appear in the default control toolbox. The Timer control is more usually used in straight VB projects rather than VBA, and looping through code and adding in a coded delay may be a more effective way of doing this.
Anthony
Mon 20 Apr 2009, 14:13Delegate Simon said...
RE: Excel VBA
An example of a coded delay written in to a loop can be found in the
Mon 20 Apr 2009, 14:34Trainer Anthony said...
RE: Excel VBA
That's very useful, Simon. Thanks!
Anthony
