ExcelBanter - Drop Down Calendar

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Drop Down Calendar (https://www.excelbanter.com/excel-discussion-misc-queries/64472-drop-down-calendar.html)

Drop Down Calendar

How can I insert a drop down calendar to a cell in a worksheet?

Drop Down Calendar

Thanks for the help- Perfect!

"BJ Snyder" wrote:

How can I insert a drop down calendar to a cell in a worksheet?

Drop Down Calendar

BJ

Check out Ron de Bruin's site for a calendar control.

http://www.rondebruin.nl/calendar.htm

Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 07:42:05 -0800, BJ Snyder <BJ
wrote:

How can I insert a drop down calendar to a cell in a worksheet?

Drop Down Calendar

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 wrote in message ...
How can I insert a drop down calendar to a cell in a worksheet?