How to use this? getting error message.
On Tue, Oct 30, 2012 at 8:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Execute it at 8 o clock*
* *
*Sub ShowPopUp()*
* *
*Msgbox “Send Massange”*
*Application.OnTime Now+Timevalue(“01:00:00”),”ShowPopUp”*
* *
*End Sub*
* *
*Sub
: Puttu * puttu...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wed, October 31, 2012 2:39:11 AM
Subject: Re: $$Excel-Macros$$ Creating Alarm/Alert MSG for every Hour
How to use this? getting error message.
On Tue, Oct 30, 2012 at 8:48 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Execute
Execute it at 8 o clock
Sub ShowPopUp()
Msgbox Send Massange
Application.OnTime Now+Timevalue(01:00:00),ShowPopUp
End Sub
Sub StopPopUp()
On Error Resume next
Application.OnTime Now+Timevalue(01:00:00),ShowPopUp,,False
End sub
Regards
Rajan verma
+91 7838100659