| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Calendar
How can I insert a drop down calendar to a cell in a worksheet?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Calendar
Try
Use the Calendar control to fill in dates http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "BJ Snyder" <BJ wrote in message ... How can I insert a drop down calendar to a cell in a worksheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Calendar
Thanks for the help- Perfect!
"BJ Snyder" wrote: How can I insert a drop down calendar to a cell in a worksheet? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Calendar
BJ
Check out Ron de Bruin's site for a calendar control. http://www.rondebruin.nl/calendar.htm Gord Dibben MS Excel MVP On Wed, 11 Jan 2006 07:42:05 -0800, BJ Snyder <BJ wrote: How can I insert a drop down calendar to a cell in a worksheet? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Calendar
Ron,
This is great, I don't need it right now but I'm sure that it'll come in hady one day. I narrowed the Range down from A1:A20 to B7:B8 and called them "Start Date" & "End date" in A7 & A8 respectivly. In C8 I've put a validation to trap End date being BEFORE Start date...... =IF(B8<B7,"END Date can't be Before START Date", " ") That works nicely as well if anyone else needs it. Thanks again Ron Best Wishes John "Ron de Bruin" wrote: Try Use the Calendar control to fill in dates http://www.rondebruin.nl/calendar.htm -- Regards Ron de Bruin http://www.rondebruin.nl "BJ Snyder" <BJ wrote in message ... How can I insert a drop down calendar to a cell in a worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down calendar | Excel Discussion (Misc queries) | |||
| How do you create a calendar drop down in excel? | Excel Discussion (Misc queries) | |||
| drop down menu with calendar entry | Excel Discussion (Misc queries) | |||
| Is there any way to create a drop down calendar into a cell in ex. | Excel Discussion (Misc queries) | |||
| create calendar drop down list in Excel sell | New Users to Excel | |||
Linear Mode
