From: Originalgoth on
Ron,
This is great, I don't need it right now but I'm sure that it'll come in
hady one day.

I narrowed the Range down from A1:A20 to B7:B8 and called them "Start Date"
& "End date" in A7 & A8 respectivly.
In C8 I've put a validation to trap End date being BEFORE Start date......
=IF(B8<B7,"END Date can't be Before START Date", " ")

That works nicely as well if anyone else needs it.

Thanks again Ron
Best Wishes
John


"Ron de Bruin" wrote:

> Try
>
> Use the Calendar control to fill in dates
> http://www.rondebruin.nl/calendar.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "BJ Snyder" <BJ Snyder(a)discussions.microsoft.com> wrote in message news:4EC093BF-0E30-4692-987B-EB2C7B664D5D(a)microsoft.com...
> > How can I insert a drop down calendar to a cell in a worksheet?
>
>
>