Timer control in Excel ?

Hi all
Has anyone been able to implant a VB timer control & routine into an Excel spreadsheet ? I cant seem to figure it out...
TIA
Roger

Hi,

There are probably a lot better ways of doing this but...You could try building an activex control with a timer in it like this...

Option Explicit

Public Event Alarm()

Public Sub setInterval(x As Integer)
Timer1.Interval = x
End Sub

Private Sub Timer1_Timer()
RaiseEvent Alarm
End Sub


....then open your spreadsheet - go to the controls toolbox in menus and select 'more controls' find your active x and put it in the sheet.

- then inside the vba for the sheet..


Private Sub MT1_Alarm()
MsgBox "hello world"
End Sub

Sub x()
MT1.setInterval 5000
End Sub

Good luck.

Thanks !
That looks as though it should work,I need to investigate this further.....
rog1111

"..he looked at the clock & saw that it was 11:11, how odd.."