You might want to take a look at Ron de Bruin's site for some tips/code/free
calendar control:
http://www.rondebruin.nl/calendar.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

GURU wrote:

FOR EXCEL, IS THERE A WAY TO HAVE A DROP DOWN CALENDAR THAT WILL ALLOW YOU TO
CLICK A BUTTON FOR A DATE ENTRY?

--

Dave Peterson