Have a peek at the instructions and code at Ron de Bruin's site.

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


Gord Dibben MS Excel MVP

On Sat, 30 Dec 2006 15:10:00 -0800, fzeiba
wrote:

I am building a multiple sheet orderform (template). I want to have
"calendars" available as drop downs in certain fields for date selection. I
understand how to utlize the Data...Valadation... in order to add a drop down
of a list in a work sheet, however I have been unable to find a way to add a
calendar. Any and all recomendations are appreciated.............Thank you.