Help with timer control in Excel

[evileconomist]

Hi

I want to insert a timer control in my excel worksheet, however I can't find the control. In the VB editor it's in the control toolbar but in the VBA editor it's absent.

Checking the project references, in VBA, there doesn't seem to be a timer-control.

[cron912]

Personally, I try to do as little coding in Excel as possible, so I can't help you there. But if the Timer control isn't available, you might try creating your own timer via API calls, using SetTimer and KillTimer, both in user32.dll.

[evileconomist]

I have a rather silly solution

I'm going to wrap the existing timer control from VB into an "activeX" control, then use the activeX control in Excel.

Seems a bit lame considering that the VB timer control probably is an activeX control, if I only could get its name.