msg display after fixed interval of time

tushar.tushar said:

Dear Friends,

I am trying to create a form in VBA . My concern is

1) A message box should be displayed after every 15 minutes ( any message, say hi)

2) After the message , the timer should start again and re-display the same message again after 15 minutes ... the message loop should continue until i close the form.

Thanks in advance.

Click to expand...

Sub MMsgboxTimer()

Application.OnTime Now + TimeValue("00:15:00"), "ShowMsgbox"

End Sub

Sub showmsgbox()

If MsgBox("Hello", vbOKCancel) = vbOK Then
    Call Macro2
End If

End Sub

TimeValue("00:15:00")

TimeValue("00:00:05")