98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA
Excel VBA
Resolved · Low Priority · Version 2003
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
Mon 27 Apr 2009: Automatically marked as resolved.
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 tip:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
