See Ron de Bruin's site for adding a Calendar Control to the worksheet.

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


Gord Dibben MS Excel MVP

On Fri, 17 Oct 2008 13:20:01 -0700, Jeff
wrote:

Just explored the Date Validation for drop down menu's, it is very helpful.

Wondering if there is an option to add a calender similar to the drop down
menu, we use a spreadsheet to track jobs and enter dates all the time, would
be nice if a calender would be availible for those cells.

Thanks