| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I do a drop down box with calender in excel?
I want a drop down box that shows the current month calender that I can
choose a particular date to be inserted into my excel sheet. Any ideas would be great. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I do a drop down box with calender in excel?
Rosie,
You didn't tell us you Excel version and it's slightly different so have a looke here http://www.rondebruin.nl/calendar.htm -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rosie65" wrote: I want a drop down box that shows the current month calender that I can choose a particular date to be inserted into my excel sheet. Any ideas would be great. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I do a drop down box with calender in excel?
See: http://www.ozgrid.com/VBA/excel-calendar-dates.htm
-- Regards Dave Hawley www.ozgrid.com "Rosie65" wrote in message ... I want a drop down box that shows the current month calender that I can choose a particular date to be inserted into my excel sheet. Any ideas would be great. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I do a drop down box with calender in excel?
The main question is: "How deep you intend to dig" ?
If you want it simple - try the following suggestion. 1) Column D is the List source of cells B3 'Data Validation' 2) Col. D can be Hidden but not deleted. 3) The dates will, Automatically, update on every 1st. of month. 4) As there always are at least 27 days, and not more than 31, in any month, the formulas get a little bit "tricky" in the last 3 cells. http://img27.imageshack.us/img27/1323/nonamejh.png Micky "Rosie65" wrote: I want a drop down box that shows the current month calender that I can choose a particular date to be inserted into my excel sheet. Any ideas would be great. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I do a drop down box with calender in excel?
"at least 27 days" is a typo.
It should read: "at least 28 days" Micky "מיכאל (מיקי) אבידן" wrote: The main question is: "How deep you intend to dig" ? If you want it simple - try the following suggestion. 1) Column D is the List source of cells B3 'Data Validation' 2) Col. D can be Hidden but not deleted. 3) The dates will, Automatically, update on every 1st. of month. 4) As there always are at least 27 days, and not more than 31, in any month, the formulas get a little bit "tricky" in the last 3 cells. http://img27.imageshack.us/img27/1323/nonamejh.png Micky "Rosie65" wrote: I want a drop down box that shows the current month calender that I can choose a particular date to be inserted into my excel sheet. Any ideas would be great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a calender drop-down? | Excel Worksheet Functions | |||
| calender as a drop down list option in excel | Excel Discussion (Misc queries) | |||
| calender drop down in an exel sheet | Excel Worksheet Functions | |||
| How can I create a monthly calender as a drop down list in excel? | Excel Discussion (Misc queries) | |||
| Exel Calender drop down box 2005 | Excel Discussion (Misc queries) | |||
Linear Mode
