Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel VBA
Resolved · Low Priority · Version 2003
Reply 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?
For upcoming training course dates see: Pricing & availability
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
Reply 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
RE: Excel VBA
That's very useful, Simon. Thanks!
Anthony
Mon 27 Apr 2009: Automatically marked as resolved.
|