Thread: Running a Sub Procedure every 5 seconds
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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

Reply With QuoteReply With Quote