Email:      Pass:    Pass?
Close Window   
Subscribe for Email Updates!
Excel tips, help, and more!


Free Excel Forum

Drop Down Calendar

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

In a cell I want to have a drop down calendar of the current month. I
downloaded a template of a calendar and tried data valadation but it only
displayed the source range. Any ideas?

Similar Excel Video Tutorials

Helpful Excel Macros

Create a 12 Month Calendar With The Current Day Highlighted in Excel
- Create a 12 month formatted calendar on a new tab in Excel with the current day highlighted. This macro creates a nicel
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
- Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows yo
Remove All Data Validation from a Cell in Excel
- Remove all data validation from a cell in Excel with this free Excel macro. This is a great macro to use when you need
Get Values from a Chart
- This macro will pull the values from a chart in excel and list those values on another spreadsheet. This will get the s
Create a Bar Chart With a Macro in Excel
- Create a bar chart in Excel with this macro. You will be able to quickly and easily turn any range of numbers and data

Similar Topics

Ok.. So I've downloaded Mscomct2.ocx and mscal.ocx and registered, put in system32, restarted, etc..

Trying to create a calendar in VBA but no matter what I do, the option for MonthView or MSCal isn't available.

I've done two hours of google searching, tried a hundred different recommendations, and nothing has worked.

I'm running Windows 7 HomePrem x64 and Excel 2010... Is there a way to get a working calendar like in the old days?

If I can't get an actual visual calendar, I guess I could do drop down menu for month/day/year, but I'd much prefer a calendar.

Any ideas?

Okay, in need of more help.

I would like to create a drop down menu within a cell that brings up a calendar, from which the user can click a date and that date is populated into the cell w/the drop down.

So far, I've not been successful, other than using the calendar control, which is a full-time displayed calendar that is bound to a single cell. I have a column of cells that each will potentially have a different date. I would like each cell to have independent drop downs, from which dates can be selected and populated accordingly.

All I've been able to find that is remotely close is this: Unfortunately, his recommended files that I downloaded did absolutely nothing. Any other ideas?

Thanks for looking.

Hello Everybody,

Greetings from UAE. I need your support.
I have created a drop-down list to select the according month.
Now I would like to link this drop-down cell to the calendar, e.g. when I select January, automatically 1.1.2015 should be displayed.

Training Calendar.jpg

Thank you already in advance.

Hello All,

I was assigned this project and would need some help in getting started. Basically what needs to be done is have a calendar (template which I downloaded off the web) and for each date there needs to be a drop down list with 3 selections. When selecting an option from that list a cell outside of the calendar will display a description of events for that team on that day. Therefore the description needs to be static and unique to the team.

any help would be great. I have adjusted the calendar template but thats about it. Oh! and filled out my 3 selections for my drop down list. Lets call them Peter, Paul, Mary.


Does anyone now how I can create a drop down calendar in a given cell. The kind that shows the small calendar icon and when click on you can pick month, day, year.

I am trying to make an interoffice work order for maintenance issues and need
to create a drop down calendar with a box with a button (icon) that when
clicked on shows the calendar to pick the date and enter it into the box. I
know how to insert a calendar that stays on the page but does not drop down.
I am using Microsoft Excel 2003. Help!!!!


I want to make a calendar using VBA that fills in my calendar template in excel with the dates of the month e.g. 1 2 3 4 5.....31 but start them under the corresponding DAY. So Each month has a header starting sunday through to saturday and I want to get it so it starts the 1st of the month under the correct day. This is important as I want the calendar to be dynamic and update based on a drop down which chooses the year. Here is my project so far and on the sheet called calendar is the spec of what Im trying to do. i also saw this post about a vba calendar creator but I have no idea how to do this any help would be great.

thats the file

this is the post:

My file containing what I've done so far:

Hope you can help,


Hi, I'm trying to put together a calendar on Excel using a calendar template I downloaded.

I want to be able to type a list of events and the day they occur, and have the calendar automatically populated with this data. Do you have any suggestions about how to go about this?


Hi all ,

Among all topics i didnt find what i need, what i need exactly is in a certain cell i need to insert a combo box form and when i click the arrow to drop down a small calendar from which i can click the needed date .

It is not a show calendar form button i need so when i click it it pop ups a calendar .
This didn't work

I appreciate very much your help .

I'm having trouble creating a drop down menu bar for this calendar attached.

I want the user to be able to change the month using a drop-down bar and have a new sheet appear, copied from the previous one (names and IDs intact). (I previously used a downloaded template that would switch between months, but the data entered in September completely copied over to October and created all sorts of errors)

Since I'm trying to learn how to utilize this program better I'm not looking for exact instructions, but more of guidance towards the tutorials and practices needed to accomplish my task.

Thanks for any assistance!

I have been looking for a good working drop down calendar with a good layout.
I suffer the web from all over including the topics and links from this forum.
I could not found one that works 100%.

When I click a cell B2, a drop down or pop-up calendar will drop and below the
cell at the same position every time. I also like to see week number on the left
side (nice to have). Once the date is picked, the date will copy to cell B2.
calendar position can be changed is nice ti have.


Hi all,

Is it possible to have a drop-down calendar in Excel? If yes, how would I accomplish that? E.g. if I wish to have all cells in Column C to have a drop down that would then show me the calendar.

Kind regards.

I recently did a calendar on Excel 2010, the code and everything else on the worksheet is fine but when I emailed it to someone to use they couldn't get the calendar to work.

I downloaded Calendar Control 11 to create this, is it because other users don't have this file that my calendar will not work for them? Any help at all will be kindly appreciated.



I've a straight forward shift pattern rota in a vertical table - I'm trying to have it display automatically in a visual calendar to make it easier for people to see and understand.

Online Example.xls

In the attached, "2014 Calendar" is just a calendar template I found online and I've a drop down in G1 which links to the table in "Rolling Rota".

If I select "Bob" then I am trying for all of his shifts to populate, matching the date in the calendar sheet against the data in the rota sheet.

That's the main part and I'm stumped. Have searched through the forum here and tried lots of previous examples but can't find one that works. I'm not at all precious over the calendar layout - if there is a better one for this function then I'll take it.

I'd like to future proof this if possible, so if it's at all possible to make the calendar itself incorporate a drop-down (i.e. in B2) where you can select years and the calendar then relabels itself (i.e. the correct date by day column; I guess the formatting of the borders by month would be manual.... but that'd be easy to do)

Thanks for any help, advice or pointing at a resolution elsewhere!


I have developed the pop-up calendar in excel using VB and macro. Now I am able to open a pop-up calendar by double clicking in a cell of any spread sheet.
I have one requirement.
Assume I enter a date by selecting from the pop-up calendar in a cell, say for example, I enter 25/09/2010 as date in cell.
When I open the pop-up calendar in another cell, I want the pop-up calendar to open 'Sep' month.

Presently, it is opening the current month instead of the month value entered in the other cell.

Please advise.


I have been able to successfully use the built-in calendar function to create a drop down calendar for the user to input a date, which then populates any given cell to which I link the calendar functionality.

My question is - is there a way to link the same calendar functionality to MULTIPLE cells in a column?

Ideally, my spreadsheet will contain one column into which only dates will be entered. I would like to allow the user to click on THE SPECIFIC CELL into which they would like the date to appear; this action will initiate the pop-up drop-down calendar REGARDLESS OF THE ROW in the date column; the user will then select the desired date from the calendar, and that date will then populate the chosen cell.

Thanks in advance.

Hi All

I'm using Excel 2002 and am currently creating a holiday tracker.
I am looking to integrate a calendar button into this sheet.
For e.g. when someone clicks on the button a popup window opens up with the calendar for 2008.
I am not looking for a drop-down calendar. I simply want users to see the yearly calendar when they click on the button.

Any help would be appreciated.

Thank you.

A Bellad

I have figured out creating drop down menus using the validation option but
what I would like to do is have a scrollable calendar in that field. Is there
a way to put a calendar in pull down menus or would someone recommend another
way to approach this?


Can I have a drop down menu in cell A4 to show calendar so as to click date this then stays in cell A4
The calendar must contain the full 12 months "month by month" & auto change year as it moves from 2009 to 2010
Any help thanks

I got this attached sheet from this very forum. I was wondering is there a way out that the pop out calendar could show two months calendar i.e as now when i click on the calendar button it shows up August's calendar, i want it to show up August's as well as next month's (September) calendar also but in the same window.

Any help or advice would be really appreciated.


I'm having trouble copying rows of cells from Excel to a Outlook calendar appointment. They do not keep the format of the spreadsheet. If I copy them from a csv file, I am able to copy and retain the info in each cell. My goal is to create a calendar template that I can copy from Excel data into the calendar and post into a shared calendar. Any ideas?


I am working in a userform and I need to find out how I could set a field for date and have a calendar drop down in it?

Any ideas or codes anyone?

Thanks in advance!

Hey Guys -

Wondering -I want to create a spreadsheet and have a Row of cells each with its own Drop down calendar so that the user may select the date of choice without manually keying the data.--- A calendar that shows the entire month and the user can select the date and once the date is selected it will read automatically in the cell.

similar to the Data Validation option that allows the user to ONLY select whatever is placed in the cell drop down.

Is this even possible?

Any tips would be great! Thanks!

This is my 2nd post with no solutions yet. i created a calendar with formulas so that it can be used again in the future. I also have a row in between the weeks with drop downs for vacations, sick, personal. But the formula is counting the drop down row. For example: the 1st falls on sun, then the next row is blank for my drop downs and the next row is showing 9th-15th so it skip a whole week due to the extra row. HELP!! NOTE: i have to use this calendar otherwise i would find one online.

I'm in need of some assistance.
I have a worksheet that has a Calendar on a worksheet from Calendar Control 8.0.
I want to be able to pick a month from the calendar and press a button to convert the selected month into a worksheet. I have a custom made calendar worksheet that I would like for it to be converted into.

I have uploaded my workbook. It contains the custom calendar worksheet as well as the calendar control.
The file is called "calendar.xls".

Any help would be greatly appreciated!!