When editing Excel, we usually need to add some date to the excel table to identify different work with different dates. Usually, we add those dates manually, but there is a way to select a date from a calendar so that we can save our hand from typing words or prevent wrong typing of date in Excel. Now we would show you the way to create a drop-down list calendar in Excel.

Here we would show you creating a drop-down list calendar from Developer tab on the Excel ribbon. Due to the difference between Excel 2007 and Excel 2010,2013, we would show different ways to show developer tab in Excel ribbon.

Create a dynamic monthly calendar in Excel. Please do as follows to create a dynamic monthly calendar in Excel. You need to create a Form Controls Combo Box in advance. Click Developer Insert Combo Box (Form Control). See screenshot: 2. Then draw a Combo Box in cell A1. Create a list with all month names. Right-click the drop-down list calendar and click Properties from the list. In the Properties dialog box, enter a specific cell in the LinkedCell box, and then close the dialog, you would find the date would be displayed in the specified cell. Step 6: Click 'Design Mode' from 'Developer' Tab to activate the drop-down calendar; Step 7: Click the small triangle and you can pick the date from the calendar; Step 8: Setup the drop-down calendar properties by clicking the ' Design Mode ' and select the calendar box, then click the ' Properties '.

In Excel 2007, if you never show Developer tab on the Excel ribbon before, you can navigate to the Office button and select Excel Options. Then select Popular in the right bar of the Excel Options dialog and check the Show Developer tab in the Ribbon box. Last, click OK.

For Excel 2010 and 2013, just navigate to the File item, then find and click Options. In the coming dialog, first click Customize Ribbon, then just find Developer item in the left part of the Customize Ribbon section. Click Add button to add the Developer item to the right part and click OK. Apple final cut pro x 10.4 tnt dada dmg.

Now you can see that the developer item is shown on the ribbon. Moana full movie download hd.

Click the Developer item and select the Insert option in its subcategory. Find the icon labeled with More Controls.

In the More Controls dialog, just select Microsoft Date and Time Picker Control 6.0 and then click the OK button.

Then draw the drop-down list calendar to the worksheet where you want it to appear, and resize the box with dragging its corner. Right-click the drop-down list calendar and click Properties from the list. How to verify rolex serial number. In the Properties dialog box, enter a specific cell in the LinkedCell box, and then close the dialog, you would find the date would be displayed in the specified cell.

Related Articles:

-->

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Summary

This article contains a sample Microsoft Visual Basic for Applications macro (sub-procedure) that prompts you for the month and year and creates a monthly calendar by using a worksheet.

Resolution

Note

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

To create the calendar, follow these steps.

Microsoft Excel 2003

Create a workbook.
On the Tools menu, point to Macro, and then select Visual Basic Editor.
On the Insert menu, select Module.
Paste the Visual Basic for Applications script from the 'Sample Visual Basic procedure' section into the module sheet.
On the File menu, select Close and Return to Microsoft Excel.
Select the Sheet1 tab.
On the Tools menu, point to Macro, and then select Macros.
Select CalendarMaker, and then select Run to create the calendar.

Microsoft Excel 2007 or later

Create a workbook.
On the Developer ribbon, select Visual Basic.
On the *Insert menu, select Module.
Paste the Visual Basic for Applications script from the 'Sample Visual Basic procedure' section into the module sheet.
On the File menu, select Close and Return to Microsoft Excel.
Select the Sheet1 tab.
On the *Developer ribbon, click Macros.
Select CalendarMaker, and then select *Run to create the calendar.

Note

If the Developer ribbon is not visible, open Excel Options to enable it. In Excel 2007, the option is available on the Popular menu. In Excel 2010, the option is available on the Customize Ribbon menu.

How Do I Insert A Calendar Drop Down In Excel Mac

Sample Visual Basic procedure

How Do I Add A Calendar Drop Down In Excel For Mac

You can add other code to customize the calendar to meet your needs. Insert extra rows for entry on the screen for each day or resize the screen to see the whole calendar based on screen size and resolution.

Drop Down Calendar In Excel 2011