Insert Drop Down Calendar In Excel 2016 Without Date Picker

Click design mode from developer tab to activate the drop down calendar.

Insert drop down calendar in excel 2016 without date picker. I appreciate your help. From office 2016 the datepicker is no longer supported. Here are things you can set up through.

Create a drop down list calendar in excel with the activex control method b. Go to the developer tab controls group click insert and then click the more controls button under activex controls. I can t use macros vba or add ins due to various reasons.

If you still want to install the datepicker you first have to download and install mscomct2 ocx. The else statement tells the compiler to not display the date picker when any cell except that in the c column is selected. This tutorial shows you how to create a calendar in excel worksheet using the activex control.

This tutorial shows you how to create a calendar in excel worksheet using the activex control. With drop down calendar in excel worksheet you can easily select a specific date from it without manually typing. When i click on a cell a calendar should pop up and i should be able to pick a date from the calendar.

Click the small triangle and you can pick the date from the calendar. Is there any way that i could get this. As one other answer mentioned perhaps your solution is to use the built in month picker which does not require importing controls.

Assume you cannot do that either s. Else visible false. If this was an interview question i can picture the interviewer adding.