docs / articles / Microsoft Date and Time Picker Control: Not in List

Microsoft Date and Time Picker Control: Not in List

Eric Jul 09, 2026 2026-07-09 04:40:47

Are you facing issues with the Microsoft Date and Time Picker control not displaying a list of dates or times? You're not alone. This is a common problem that can be caused by a variety of factors. Let's delve into this issue, explore its potential causes, and provide practical solutions to help you resolve it.

Microsoft Date and Time Picker Control - How To Enable and Use It
Microsoft Date and Time Picker Control - How To Enable and Use It

Before we dive into the solutions, it's crucial to understand that the Date and Time Picker control in Microsoft is a powerful tool that allows users to select dates and times easily. It's often used in forms and applications to collect date and time inputs. However, when it fails to display a list of dates or times, it can lead to user frustration and functionality issues.

How to create a drop down list calendar (date picker) in Excel?
How to create a drop down list calendar (date picker) in Excel?

Understanding the Microsoft Date and Time Picker Control

The Microsoft Date and Time Picker control is a part of the .NET Framework and is used extensively in Windows Forms and ASP.NET applications. It's designed to provide a user-friendly interface for date and time selection, improving the user experience and reducing errors in data entry.

Excel VBA USERFORMS #25 Date Picker Calendar revealed! Loop through Userforms and Controls  Example
Excel VBA USERFORMS #25 Date Picker Calendar revealed! Loop through Userforms and Controls Example

At its core, the control uses a calendar view to display a list of dates. When you click on a date, it's selected, and the control updates the associated text box with the chosen date. Similarly, for time selection, it displays a list of times that can be selected. However, when this list fails to appear, it can lead to confusion and functionality issues.

Common Causes for the Microsoft Date and Time Picker Control Not Displaying a List

How to Add an Updating Date and Time in Microsoft Word (PC & Mac)
How to Add an Updating Date and Time in Microsoft Word (PC & Mac)

Several factors can cause the Microsoft Date and Time Picker control not to display a list. Here are some of the most common causes:

  • Incorrect Control Properties: Incorrect settings in the control's properties, such as ShowUpDown, ShowCheckBox, or ShowNow, can prevent the list from appearing.
  • Incompatible DateTimePicker Mode: The Mode property of the DateTimePicker control determines whether it displays a date, time, or both. If this is set incorrectly, the list may not appear.
  • Form or Control Size: If the control or the form it's on is too small, the list may not have enough room to display and thus doesn't appear.
  • Z-Index Issues: The Z-Index property determines the stack order of controls. If the control's Z-Index is too low, it may be obscured by other controls, preventing the list from appearing.

Solving the Microsoft Date and Time Picker Control List Display Issue

Use This Free Excel Date Picker to Enter Dates on Worksheet
Use This Free Excel Date Picker to Enter Dates on Worksheet

Now that we've identified some common causes, let's explore solutions to resolve the issue:

  1. Check and Adjust Control Properties: Ensure that the ShowUpDown property is set to true. This allows the control to display the drop-down list of dates or times. Also, check the ShowCheckBox and ShowNow properties to ensure they're set appropriately.
  2. Adjust the Mode Property: Ensure that the Mode property is set to DateTime, Date, or Time, depending on your requirements. If it's set to None, the list won't appear.
  3. Resize the Control or Form: If the control or form is too small, increasing its size may resolve the issue. You can do this in the Properties window or by manually resizing the control or form in design view.
  4. Adjust the Z-Index: Ensure that the control's Z-Index is set appropriately. You can do this in the Properties window or by using the BringToFront or SendToBack methods in code.

Additional Troubleshooting Steps

How to Use Excel UserForm as Date Picker (with Easy Steps) - ExcelDemy
How to Use Excel UserForm as Date Picker (with Easy Steps) - ExcelDemy

If the above solutions don't resolve the issue, there are a few additional troubleshooting steps you can take:

Check for Conflicting Controls: Ensure that there are no other controls on the form that are causing a conflict with the DateTimePicker control. You can temporarily hide other controls to see if this resolves the issue.

an image of a calendar in microsoft office 365 with the date and time tab open
an image of a calendar in microsoft office 365 with the date and time tab open
Excel Date Picker - How to Insert? (Step by Step Examples)
Excel Date Picker - How to Insert? (Step by Step Examples)
How to Add Date Picker Calendar Drop Down in MS Excel (Easy)
How to Add Date Picker Calendar Drop Down in MS Excel (Easy)
Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more
Mastering Excel Date & Time: Serial numbers, Networkdays, Datevalue, and more
the date and time functions in excel, with instructions to use it for each task
the date and time functions in excel, with instructions to use it for each task
302K views · 10K reactions | How to insert a calendar and date picker in Excel‼️ 🗂️ Don’t forget to save this post! 🧑‍🏫 Get your FREE Excel templates with the link in our bio! 🤯 Follow us on TikTok, YouTube, Twit | CheatSheets
302K views · 10K reactions | How to insert a calendar and date picker in Excel‼️ 🗂️ Don’t forget to save this post! 🧑‍🏫 Get your FREE Excel templates with the link in our bio! 🤯 Follow us on TikTok, YouTube, Twit | CheatSheets
How to Quickly Insert Date And Time In Excel
How to Quickly Insert Date And Time In Excel
MS Outlook Calendar: How to Add, Share, & Use It Right | Envato Tuts+
MS Outlook Calendar: How to Add, Share, & Use It Right | Envato Tuts+
the excel time and date sheet
the excel time and date sheet
Heardle Archive: How to Play Old Heardle Games
Heardle Archive: How to Play Old Heardle Games
Fix AOL's certificate not trusted error in a few easy steps
Fix AOL's certificate not trusted error in a few easy steps
NEW Date Picker in Excel for Web – Finally Here
NEW Date Picker in Excel for Web – Finally Here
Never waste time typing out dates again with this calendar tool. 🗓
Never waste time typing out dates again with this calendar tool. 🗓
Time blocking method applied to weekly calendar view
Time blocking method applied to weekly calendar view
How to create a date picker in Excel!🙏
How to create a date picker in Excel!🙏
Calculate days from/before date in Excel
Calculate days from/before date in Excel
Excel shortcuts
Excel shortcuts
how to format and change date order
how to format and change date order

Review Your Code: Check your code to ensure that you're not accidentally hiding or disabling the control. Also, ensure that you're not setting the control's Visible property to false.

In conclusion, while the Microsoft Date and Time Picker control not displaying a list can be a frustrating issue, it's often a simple problem with a straightforward solution. By understanding the common causes and following the troubleshooting steps outlined above, you should be able to resolve this issue and get your control working as expected. If you're still having trouble, don't hesitate to seek further assistance from Microsoft's documentation or community forums.