msg display after fixed interval of time

[tushar.tushar]

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.

 

[andrewk32]

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.

You can try this code.

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

You need to make it an OK Cancel Messagebox else you would be caught up in an infinite loop Try it out just change the

TimeValue("00:15:00")

to

TimeValue("00:00:05")

It will go off every 5 seconds so you don't have to wait 15 mins to test it