| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a Sub Procedure every 5 seconds
Is it possible to program this?
Alan Beban |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running a Sub Procedure every 5 seconds
Alan,
Use Application.OnTime. See www.cpearson.com/Excel/OnTime.aspx for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Alan Beban" wrote in message ... Is it possible to program this? Alan Beban |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running a Sub Procedure every 5 seconds
Chip Pearson wrote:
Alan, Use Application.OnTime. See www.cpearson.com/Excel/OnTime.aspx for details and example code. Perfect! Thank you. The online help I saw didn't deal with repeating and I decided not to try to reinvent the wheel. Thanks again, Alan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running time of procedure increases | Excel Programming | |||
| Running Ontime's procedure while another function is running? | Excel Programming | |||
| Procedure not running automatically... | Excel Programming | |||
| Running Userform Procedure | Excel Programming | |||
| Procedure to detect if an application is running | Excel Programming | |||
![Alan Beban[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
