1

Hi All, I want to get the functionality of the timer control in excel vba. Is it possible? My requirement is that a specific function needs to be called automatically every 25 seconds Regards, Subbu S.

2

It is working. Thanks!!!

3

Hi Subbu,

Use this Code:

Sub timerMsg()
Dim alertTime
alertTime = Now + TimeValue(“00:00:25”)
Application.OnTime alertTime, “sheet1.msg”
End Sub

Sub msg()
MsgBox “25 Seconds up!”
End Sub

Regards
Veena