07-14-2001, 11:52 AM
Has anyone been able to implant a VB timer control & routine into an Excel spreadsheet ? I cant seem to figure it out...
07-16-2001, 09:22 AM
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...
Public Event Alarm()
Public Sub setInterval(x As Integer)
Timer1.Interval = x
Private Sub Timer1_Timer()
....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"
07-17-2001, 03:39 AM
That looks as though it should work,I need to investigate this further.....
"..he looked at the clock & saw that it was 11:11, how odd.."