timer control

[Guest]

Hi all
Anyone know how to use the (a) timer control from within a vba form (excel)

Or, to make my life a tad harder, the api call

Or, do I have to make my own control

thanks in advance
ben

 

[Frank Kabel]

Hi
not quite sure but you may have a look at
http://www.cpearson.com/excel/ontime.htm

 

[Guest]

Try using the application.OnTime method to specify a start
time and the name of the procedure to run.

***********************************************
OnTime Method Example

This example runs my_Procedure 15 seconds from now.

Application.OnTime Now + TimeValue
("00:00:15"), "my_Procedure"
This example runs my_Procedure at 5 P.M.

Application.OnTime TimeValue("17:00:00"), "my_Procedure"
This example cancels the OnTime setting from the previous
example.

Application.OnTime EarliestTime:=TimeValue("17:00:00"), _
Procedure:="my_Procedure", Schedule:=False

***********************************************