View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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