View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Creating Message Box Warning

You can enter a date/time in a range, say A1.
Then in the Open, SelectionChange or Change events of the worksheet, compare
the value to the current time.

If Range("A1").Value<Now() Then
MsgBox "Time passed"
End

Is that what you mean ?

NickHK

"Mariner" wrote in message
...
I want to put various times into an excel spreadsheet, when these times

are
reached I need excel to display a message box with a warning and a ok

button
to acknowledge. Any ideas how to go about this.