How do I?

[Greg B]

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

 

[Robin Hammond]

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

 

[Ron Rosenfeld]

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

 

[Greg B]

Thanks