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.
|