calender drop down in an exel sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sinbad - 17 Nov 2005 11:52 GMT

Is it possible to have a calender drop down box to pick a date from in Excel

Signature

Regards Sinbad

Reply to this Message

Ron de Bruin - 17 Nov 2005 11:53 GMT

Hi Sinbad

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

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Is it possible to have a calender drop down box to pick a date from in Excel

Reply to this Message

Olivia Trimble - 17 Nov 2005 12:05 GMT

The only way I know is to list the calender somewhere on the spreadsheet the
go to the ceel you want the drop down box to be in, got data, validation.
Change allow "Any Value" to "List" Then highlight the list wherever you put
it in the spreadsheet.

There must be an easier way though!

Olivia

> Is it possible to have a calender drop down box to pick a date from in Excel

Reply to this Message