How do I crate a drop down Calander in a column of cells for any date

To create a drop-down calendar in a column of cells in Excel, you can use the following approach:

1. Select the Cells: Highlight the cells in the column where you want the drop-down calendar.
2. Data Validation: Go to the Data tab on the ribbon, and click on Data Validation.
3. Allow Date: In the Data Validation dialog, set the Allow option to Date. This will restrict entries in the selected cells to date values.
4. Input Message: Optionally, you can set an input message to guide users on what to enter.
5. Drop-down Calendar: To have a visual calendar for date selection, you can use a date picker control. Unfortunately, Excel does not natively support a drop-down calendar, but you can use a third-party add-in or VBA code to implement this feature.

If you want a simple solution without coding, consider using the Date Picker from the Developer tab, which allows users to select dates from a calendar interface.

For more advanced functionality, you might explore creating a custom user form with a calendar control using VBA.

This method allows users to select dates easily without having to type them manually, enhancing data entry efficiency.

References:

• MonthCalendar Control Overview (Windows Forms)
• How to Create a Month Calendar Control

How do I creating a custom user form with a calendar control using VBA.

Hi @L J, 

Thank you for posting your question to the Microsoft Q&A forum. 

According to your concern, to add a calendar dropdown in a cell, I would recommend following the below steps: 

1. Open Excel Online 
2. Format your cells to the Date format. 

The Date Picker opens automatically when the cell's format Date. Otherwise, it won't pop up. 

3. Select day, month, year, decade 

The date picker helps you to select any date quickly by changing the month or the year. 

To create a custom UserForm using VBA, I found an article that provides a complete solution to your issue. It includes detailed instructions, the full VBA code, and a downloadable demo workbook so you can see it in action. 

You can check it out here:  Full guide and VBA code: WorksheetsVBA - VBA date picker 

Simply download the demo file, enable macros, and follow the steps in the article to integrate the UserForm into your own workbook. This resource makes it easy to customize and reuse the date picker functionality. 

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link 

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.    

Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you. 

I look forward to your response. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.