Thread: Displaying Timer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAS MAS is offline
external usenet poster
  
Posts: 19
Default Displaying Timer
Hi,

I have a timeout timer running with the following code.

RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds)
Application.OnTime earliesttime:=RunWhen, procedu=cRunWhat,
Schedule:=True

Workbooks("testmatrix.xls").Sheets("Sheet1").cell b14 = RunWhen

How do I get the timer to display counting down in cell B14

?


Reply With QuoteReply With Quote