Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

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?

View Answers     

Similar Excel Tutorials

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 ...
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 allo ...
Make a Drop Down List Menu in a Cell in Excel
I'll show you how to make a drop down list menu in a cell in Excel.  This allows you to have a list appear when yo ...
Sort Data Left to Right in Excel
How to sort columns of data in Excel.  This is the same as sorting left to right. This will change the position of ...

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.

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 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 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!!

question for you guys. I have a worksheet called data which has one column called events and the other called date. and another worksheet called calendar. which has a calendar template i downloaded from microsoft. basically want to put all the events into their correct place in the calendar. anyone know of a way to do this. or can sugguest an different approach?

Hi I am using a great pop up calendar without ActiveX made by a guy called Phil Johnson. When you click a specified cell the calendar appears. The only problem is that the calendar doesn't default to today's date when it opens.

I've seen the calendar in questioned mentioned a couple of times so I was wondering if anyone could help me to solve the problem?

I have the original file Calendar source code if anyone needs it.

Many thanks

I have this calendar, and in between each week i have drop downs that show vacation, personal and sick. The problem is this is only for 2011 i need to have this calendar for future years to come. is there a way i can insert a formula that will change years and dates so that i dont have to manually do this.. NOTE i already have a calendar w formulas inside but i think its not meant to have the extra row in between each wk..

JANUARY SUN MON TUE WED THU FRI SAT 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31