Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calender drop down in an exel sheet
Is it possible to have a calender drop down box to pick a date from in Excel
-- Regards Sinbad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calender drop down in an exel sheet
Hi Sinbad
See http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "sinbad" wrote in message ... Is it possible to have a calender drop down box to pick a date from in Excel -- Regards Sinbad |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calender drop down in an exel sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move data from one sheet to another using drop down lists. | Excel Worksheet Functions | |||
how do I print 12 month calender in one sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
auto numbering an exel work book sheet everytime it opens or print | Excel Discussion (Misc queries) | |||
Why does data sometimes duplicate itself on an Exel sheet when I S | Excel Discussion (Misc queries) |