Can I set up a drop-down box with a calendar?
 

I'd like to know if Excel allows you to put drop-downs that are calendars. I
think that would be a better way to remind the user of a monthly spreadsheet
to change the date references in header rows from last period's dates to this
period's dates. I've created drop-down boxes before for Yes/No and short
lists of choices, but I think a calendar would be really neat!

Obviously, if there is a way to do this, I'd like to know how to do it.

Thanks!

Can I set up a drop-down box with a calendar?
 

Hi Roger,

Have a look here.
http://www.rondebruin.nl/calendar.htm

HTH
Martin