Calendar drop down

**NickJW** · 12-16-2010, 12:01 PM

Hi. I am using Excel 2003. I want to be able to manage a calendar in a drop down format when I select a cell. The user will then choose a date from the calendar and it will auto-fill the date in the cell. How do I manage this please?
NJW

**Richard Buttrey** · 12-16-2010, 12:23 PM

Hi,

Create a list of allowable dates, name the range of dates and then with Data Validation specify the 'list' option and enter the name you've given to the dates.

HTH

**NickJW** · 12-16-2010, 12:26 PM

Hi Richard thanks for that. I am using that system for other spreadsheets. but what I was after was what you sometimes see in internet application forms - a small calendar icon that would then open into a useable size for the user to pick a date. Do you know what I mean?
NJW

**jwright650** · 12-16-2010, 12:27 PM

I'm using a VBA Userform with MonthView1 calendar on it, and the selected date is entered into textbox when clicked and the calendar closes.

Just a Note: I've read that people have trouble with the MonthView1 calendar(various problems), but I'm so new at this that I haven't had enough time to have any trouble as of today...LOL
The only problem that I've ran into with these date pickers are that if other people use your file on their computer(access it via local network), they may or maynot be able to use the MonthView calender due to whether or not they have it loaded with their copy of Excel. For files where I'm the sole user, I've not had any trouble.

**NickJW** · 12-16-2010, 12:48 PM

John would you share the monthView1 code with the Forum?

**jwright650** · 12-16-2010, 01:19 PM

Originally Posted by NickJW

John would you share the monthView1 code with the Forum?

yes, I can...

I started to attach a file but wasn't sure if you were interested in that method or not.

To Start: click on text box "Click Here to Add Record"

Let me know what you think.....

**royUK** · 12-16-2010, 03:03 PM

See the alternatives here. Calendar controls can cause problems & are not available from Excel 2010

**jwright650** · 12-21-2010, 11:22 AM

I also got the MSCalendar (Calendar Controls 11.0) to work so there is another option for you to consider. Just keep in mind some have had trouble when multiple users try to use the same workbook from different computers. So far several computers here at work seem to be happy with this one.
Same Excel file as in my earlier post, but with MS Calendar instead of MonthView1.