If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop Down Calendar
How can I insert a drop down calendar to a cell in a worksheet?
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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(B8B7,"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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do I add a calendar function to excel as a drop down? | Dennis | Worksheet Functions | 1 | May 26th, 2005 07:13 PM |
How do you create a calendar drop down in excel? | Create a calendar drop down box | General Discussion | 1 | April 28th, 2005 04:00 PM |
create calendar drop down list in Excel sell | Bo | New Users | 1 | December 3rd, 2004 06:37 AM |
Access Calendar | lost | General Discussion | 2 | July 7th, 2004 04:58 AM |
Calendar Object | Steve | Setting Up & Running Reports | 1 | May 18th, 2004 04:44 PM |