calender drop down in an exel sheet

[sinbad]

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

[Ron de Bruin]

Hi Sinbad

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


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


"sinbad" <sinbad@discussions.microsoft.com> wrote in message news:B46C2A05-577B-4169-9CA6-CA0A4580E045@microsoft.com...
> Is it possible to have a calender drop down box to pick a date from in Excel
> --
> Regards Sinbad

[Olivia Trimble]

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

"sinbad" wrote:

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