I have a section in my workbook where a person can make an appointment,
How
can I make a message box pop-up to say "This date has already passed" if
someone puts in past date


Thanks in advance

Greg

Greg,

Use Data Validation.

1. In another cell, enter the formula =Now()
2. Set up a rule that says
a. Allow a Date
b. Greater than or equal to
c. Point the start date to the cell with the Now formula in
d. set up your input and error messages if you want to


Robin Hammond
www.enhanceddatasystems.com

"Greg B" wrote in message
...
I have a section in my workbook where a person can make an appointment,
How
can I make a message box pop-up to say "This date has already passed" if
someone puts in past date


Thanks in advance

Greg

On Sat, 12 Mar 2005 12:30:02 +1030, "Greg B" wrote:

I have a section in my workbook where a person can make an appointment,
How
can I make a message box pop-up to say "This date has already passed" if
someone puts in past date


Thanks in advance

Greg



Take a look at Data/Validation

--ron

Thanks