if time = TimeValue("12:00 PM") or time <= TimeValue("1:00 PM") then

--
Regards,
Tom Ogilvy

"Ian M" wrote in message
om...
How can I programme an individual cell in an Excel spreadsheet to
perform a task depending on what time is entered into it.

i.e. if any time is entered which falls between 12.00 noon and 1.30
pm, I want a message box to appear saying "Remember to Order Lunch".

Any ideas?

Thanks for your help.

Kind regards

Paddymichelle