Message Box to appear Thursday midday!
 

I know this is possible as long as the worksheet is open. Can anyone help me
with the macro that would pop a message up at midday Thursday?

Thanks in anticipation.


Andrew

Message Box to appear Thursday midday!
 

Sub PrimeMsgBox()
Dim nTime As Double
nTime = DateSerial(2006, 2, 23) + 0.5
Application.OnTime nTime, "myWarning"
End Sub

Sub myWarning()
MsgBox "some message"
End Sub


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"AJPendragon" wrote in message
...
I know this is possible as long as the worksheet is open. Can anyone help
me
with the macro that would pop a message up at midday Thursday?

Thanks in anticipation.


Andrew