Timer control in Excel

dunder · Mar 30th, 2004, 02:41 AM

Does anybody know how to get the timer control (as in VB6) into Excel ? I've tried adding a reference to the comctl32.ocx file, but it doesn't appear in the list of available controls. Failing that, is there any other way to get similar functionality ?

Thanks,

Dunder

Damon Ostrander · Mar 30th, 2004, 06:58 PM

Hi Dunder,

I'm not sure the Timer control can be used in Excel. This functionality is usually achieved in VBA through the Application object's OnTime method. For example

Application.OnTime Now() + 10/86400, "MyMacro"

will run MyMacro 10 seconds from now. You can get details on the OnTime method in the VBA helps.

Damon

Mar 30th, 2004, 02:41 AM	#1
dunder Join Date: Mar 2004 Posts: 1	Timer control in Excel Does anybody know how to get the timer control (as in VB6) into Excel ? I've tried adding a reference to the comctl32.ocx file, but it doesn't appear in the list of available controls. Failing that, is there any other way to get similar functionality ? Thanks, Dunder

Mar 30th, 2004, 06:58 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 3,876	Re: Timer control in Excel Hi Dunder, I'm not sure the Timer control can be used in Excel. This functionality is usually achieved in VBA through the Application object's OnTime method. For example Application.OnTime Now() + 10/86400, "MyMacro" will run MyMacro 10 seconds from now. You can get details on the OnTime method in the VBA helps. Damon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode