On Fri, 28 Nov 2003 01:39:07 -0800, "Matt Pinto"
wrote:

Many thanks for that! It works a treat.
I didn't even know the Data Validation Menu Option was
there, and it will allow me to remove a lot of VBA code.

Once again, many thanks.

Matt

Glad to help.

Whatever algorithm is used in Data Validation seems to work better for dates
than the IsDATE VBA function.

You can also use Data Validation to cause messages to pop-up when the cell is
selected.


--ron