| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create a drop down cell with dates
I'd like to create a drop down cell in excel that shows a calender so I can
select specific dates. (that looks and feels like the Time & date properties when you double click on the time on the bottom right hand corner of screen).. is this even possible? If not, any suggestions to get around this? Any help is greatly appreciated. |
|
#2
|
|||
|
|||
|
Hi Jagz
See http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jagz" wrote in message ... I'd like to create a drop down cell in excel that shows a calender so I can select specific dates. (that looks and feels like the Time & date properties when you double click on the time on the bottom right hand corner of screen).. is this even possible? If not, any suggestions to get around this? Any help is greatly appreciated. |
|
#3
|
|||
|
|||
|
Ron,
Having used the VBA code from your link, how do I adapt it for specific cells rather than a range? "Ron de Bruin" wrote: Hi Jagz See http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jagz" wrote in message ... I'd like to create a drop down cell in excel that shows a calender so I can select specific dates. (that looks and feels like the Time & date properties when you double click on the time on the bottom right hand corner of screen).. is this even possible? If not, any suggestions to get around this? Any help is greatly appreciated. |
|
#4
|
|||
|
|||
|
Hi
Use this If Not Application.Intersect(Range("A1,C5,E1:E3,G20"), Target) Is Nothing Then -- Regards Ron de Bruin http://www.rondebruin.nl "Struggling of Essex" wrote in message ... Ron, Having used the VBA code from your link, how do I adapt it for specific cells rather than a range? "Ron de Bruin" wrote: Hi Jagz See http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jagz" wrote in message ... I'd like to create a drop down cell in excel that shows a calender so I can select specific dates. (that looks and feels like the Time & date properties when you double click on the time on the bottom right hand corner of screen).. is this even possible? If not, any suggestions to get around this? Any help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) | |||
| create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
| Create a drop down in XL cell to select date | Excel Worksheet Functions | |||
| How do you create a drop down list? | Excel Discussion (Misc queries) | |||
| create calendar drop down list in Excel sell | New Users to Excel | |||
Linear Mode
