[Ian M[_2_]]

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

[Tom Ogilvy]

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

[Damien McBain]

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

should be "and" not "or"?

Damo