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

Create Calendar From "date" Column

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

Hey guys,

Hope you can help me. I need to create a calendar of sorts that will populate each date box with the information from other columns specific to a user and the date specified. Is there a way to do this?


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 ...
Get the Current Date in Excel
How to get the current date using Excel.  This method updates the date every day so that it is always accurate. To ...
Join a Date and Time into a Single Cell using VBA Macros in Excel
In order to combine a cell that has a date with a cell that has a time, using a Macro and VBA in Excel, you must su ...
Format Cells in The Short Date Number Format in Excel
This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format di ...

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
Return the ISO Standards Start of the Year in Excel - First Monday of the Year - UDF
- Return the date of the first Monday of any year with this UDF ISO Year function in Excel. This is a really simple and e
Format Cells in The Short Date Number Format in Excel
- This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format display
Return the ISO Week Number from a Date in Excel - UDF
- Return the ISO Week Number in Excel with this UDF. This is a simple to use UDF (user defined function) that returns the
Format Cells in The Long Date Number Format in Excel
- This free Excel macro formats a selection of cells in the Long Date number format in Excel. The Long Date number format

Similar Topics

Good Evening again,

As part of my big project, I was hoping that it's possible to insert or create a pop-up calendar for selecting a date. Similar to those you might see on a hotel reservation website. By clicking on the calendar icon, a larger calendar would open and one could simply click on the desired date and that date would self populate in a cell. I hope this isn't a nutty request for information. As always, thank you in advance for any help.


I created a userform to allow users to enter data. One of the issues is that we are relying on them to enter the date correct. So I wanted to create a way for the date to be prepoluted and defaulted to today, or they can click on it and a calendar with will pop up. They then select the date on the calendar, and that causes the calendar to dissapear and the date is the populated into the user box.

I managed to create a form with a calendar on it. On my Entryform I put the following:

Private Sub dte_Change()


End Sub

On the Calendar form, the code I tried taking from another forum and it doesn't seem to be doing anything.

Private Sub calendar_click()

Me.TextBox.Value = Me.Calendar.Value

End Sub

Thanks in advance for your help!


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.

Need help with creating a 2nd calendar in the same spreadsheet or use the 1st calendar but have date selected populate in a differnt cell, as I have 2 dates fields to populate.

I followed the proceedure to create a pop up calendar and it worked very nicely.

Resource: Name: "pop up calendar to choose dates? 3/23/2010"

Do I need to create a calendar in a differnt cell and when I try the 1st calendar Visual basic pops up or do I modify the current Visual basic

Start date
End date

Thank you


I have been looking around for ways to use a pop up calendar, but none of the ways I have found are specific to my needs.

I am using user forms that contain many fields that are filled out and then entered into different columns of a spreadsheet.

I currently have the user entering in the date manually with "mm/dd/yy" in the text box upon userform initialize to signal the desired format.

Is there a way to create a pop up calendar so the user can select a certain date, and then that date be entered into the text box?

I have attached my workbook
the password, when prompted, is "MillSteel"
I am using Excel 2010


I'm trying to auto-populate a calendar with certain information to track an installation schedule.

I have 4 columns that I want to format into a calendar. The first would be the install date & time, the second is the customer name and the third would be a sum of the revenue generated by the installation.

Does anyone know of a way to create this whether it be through outlook or Excel ?


I am making a "Master" tab which is used to track projects and i want to be able to click a Cell G (Start Date) and a calendar pops up to choose a start and finish date for the project.

How do i create this calendar? I'm at work so there is no enterprise edition and i am not very experienced in VBA.

Is there any straight forward way to do it? i have attached my file. Looking to put a calendar in Column G and Column H.

Your help is much appreciated.
Benefit Tracker FY14 v2.xlsx


I'm trying to track a constantly changing list of orders/shipment dates. I can import the basic information into Excel with Column A as the date and Column B the order number, then sorted by date.

What I would like to do is have a macro that will find the first and last dates, create a calendar for that time frame, and then populate the calendar with the order numbers on the appropriate date.

I'm using 2007 but am a VBA novice. Any help would be greatly appreciated.


Need help on inserting text. I am currently creating a Registration Page with activex textbox. One of the field that I am creating is the "DOB" and I am putting a Calendar button beside the text box. When clicked, the Calendar button will display a Calendar Userform that allows the user to click on the specific date he wants, after which I hope that the date will be reflected on the textbox. I tried this formula "Textbox1.Text = Calendar1.Value" and it doesn't work, any help here?


I have a UserForm in which the User will be filling out a form. I need to understand how on the date TextBox I can have a calendar pop up and populate the TextBox when a date is selected.

I have seen there is an calendar in Additional Controls and have created a small form with the Calendar on it. On my main userform I have now told the the DateTextBox on Before Update to pop up the Calendar (this all works)

My problem is now.

What do I need to write as code on the Calendar form for it to populate my other UserForm once a date is selected. How can I do this?

Dear all,

i have a problem, firstly i have a form which requires 4 dates, i was hoping to have a calendar on the form which users could select dates from. Firstly, can i use one calendar to put a date in a field, then when i tab to the next field, fix the first date selected and choose a new date to populate the next field etc etc

if not, i assume i will need to use 4 calendars, if this is the case can i have the relevant calendar hidden until the user selects the revelant date field, and then the correct calendar pops up, this way it will all look like the same calendar, but will actually be 4 different ones.

Please Help me!!


Hi, I'm extremely new to VBA and would love some advice. I'll try to explain as best I can. (Sorry for any improper wording...)

I have a little form on an Excel worksheet. It includes a field for an Organization Name, and a combo box drop-down to select a Date. On another worksheet, I have a calendar. Each date box on the calendar (ranges of three cells) has been named "May 1", etc., exactly like the options on the Date drop-down list.

I want the user to fill out the form, click a button and have the data from Organization Name to appear in the appropriate calendar box, depending on what Date the user has entered on the form.

Essentially, I want to modify this:

    Sheets("Calendar View").Activate

so that "name" refers to the value of "drop_date" (which is the name of the combo box that contains the date).

Hope I explained that correctly. Any help would be greatly appreciated!

I have created a user form that contains the calendar object. I have also
got it to show when i double click on a specific cell. It unhides(show) and
I am able to choose a date and the calendar hides and the date appears
in that cell. Question: I am trying to create a bid log where i could have
as many as 1000 cells in a column named bid start date that i need to be able to double click and place a date. What is the easiest way to copy
the macro down into the other 1000 cells, where i can double click
and the calendar will show, and I can choose a date.

Hey guys,

Im trying to create a calendar/schedule in a VBA form in excel. Basically what I want is to show a simple calendar , like the one you get with month view, and when the user double clicks a date a new form will appear just asking tha tasks/comments that must be done on this date. After filling this calendar with info the user must click on save and all dates and related tasks/comments will be saved onto an excel sheet.

Cant do it on MS projact as this calendar is part of a multipage form.

thanks in advance

I have a calendar control... I made it on 4/6/7 and it is used to save a file and populate a date to the title of the new file name (e.g., 040607.xls). That all works fine...

The problem is that the calendar always opens and defaults to the 4/6/7 date. How do I change the date so my user does not need to change the month to say 6 and then click on the correct day?

Okay, I don't know how hard this is at all, but I'm hoping for some guidance.

I have 5 sheets that show a particular date that I'm supposed to receive information. This sheet is constructed with a cell that shows the date, but then we also need to have the name of what that deliverable is populate as well.

I need to create a calendar that shows the dates we are supposed to receive that information. I'm easily able to filter, I know. However, this report is for a client that apparently doesn't know how to filter. So, I need to have a calendar that pulls the dates from each of the five sheets and puts the name of the deliver into one value, such as "Friday, December 25th" (in whatever format the date wants to be in.


Going to try to state this simple? I created a user form with 2 fields, Name and Date,
I want it to display the information in 2 seperate places. First, a Log. Second, I want their name to be displayed on the calendar.

Basically it is for vacation, when someone request "Paid Time Off", I would like to click Submit Entry on the PTO Log, and have it show the User Form, Input Data, there, and then record it to the Calendar, below the Correct Date...

Can this be done, the way it is currently formatted?

In the Future, I would like the submit Entry tab to be located on every Sheet, connecting to the User Form, but created this for illustrative purposes. Note: Calendar is already built in and active...


I created a calendar using the calendar maker. I also have data in an excel spreadsheet consisting of a column titled "van number" under which is a list of vans starting with "1". In the next column I have the title"date" with dates listed under. The final column is titled "customer name" with a list of customer names. I would like to create a calendar for van number 1 and list by date on the calendar all the customers that van should visit. Any help is greatly appreciated.

Hey Guys,
Is it possible to create a drop down calendar in 2003?

Basically i have a cell that displays the date. I would like to be able to click on the date and it open a calendar to choose a date from. Is that possible?

Hi ,

I am working on a file where i want users to click Cells on the Calendar in the Excel sheet(attached).

If user clicks on a cell in the Calendar Range("K7") populates the date selected as start date ,once the Range ("K7") is used.

and user selects next cell in Calendar, Range ("M7") is filled with Cell selected from the Calendar,

Help Please.

Many Thanks,


i have a calendar control with two calendars. I want to be able to select a date on calendar 1 and calendar 2 and place the dates in cell E20 & H20. Calendar 2 has control when I select a date. Calendar 1 = E20, Calendar 2 = H20. Calendar 1 does not need to have a date selected, but Calendar 2 should have a date.

Many Thanks.

Hi there,

I am trying to create a calendar in Sheet1 which identifies allocated time from consultants' business plans stored in their respective worksheets 2-4. Each consultant has 3 business plans. Each business plan shares the same template, containing 20 standard activities. Consultants will only ever take on a maximum of 8 activities per business plan per year but these activities will vary between each of their 3 business plans.

In Sheet1 (Calendar):

B2:I2, J2:Q2, R2:Y2 = Consultants 1-3 with activities 1-8 (sheets 2-4)
A2:A367 = 01-Jan-08 - 31-Dec-08

In Sheet 2 (Consultant1 Business Plan):

A2:A20 = activities
C2:C20 = start date
D2:D20 = finish date

A21:A41 = activities
C21:C41 = start date
D21:D41 = finish date

A42:A63 = activities
C42:C63 = start date
D42:D63 = finish date

If Consultant1 is starting an activity on 01-Jan-08 and finishing on 14-Jan-08 I want this information to be pulled accross to the calendar so that B2-B15 shows the activity being worked on. PLEASE NOTE that in the business plan I only have a start and finish date. In the calendar I want the period from the start and finish date to be populated.

The calendar allows for 8 activities per date i.e. each consultant has 8 columns. I want the the calendar to always populate the left most column available for a particular period. E.g. if Consultant1 starts and finishes 1 activity between 01-Jan-08 and 14-Jan-08 and starts and finishes another activity between 12-Jan-08 and 31-Jan-08 the first would pull accross to B2-B15 and the 2nd would pull accross to C12-C32.

Hope you can help?!

Many thanks


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!

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!


I have two excel sheets (Source Data) and (Calendar). I am populating "Source Data" by running a report. I need the Start Date and End dates from "Source Data" to populate the correct date cells on my Calendar Grid.

In addition I need my date cells in the Calendar Grid to consist of merged cell data from "Source Data" so when users view the grid they can see the detail of each entry.

Each row represents a room in a hotel. I am trying to display who is in each room, what date they arrive and what date they depart for any given month.

My sheet would typicaly cover 5 months (December to April).

Thanks for your help!