Please remember to mark the replies as answers if they helped.
Please feel free to post back if you need further assistance on this. Hope the above information can be helpful.
Click on a cell and insert the calendar control, customize the control under design mode, then turn off Design Mode to active the control. Go to Developer > Insert, click the More Controls button, select the Microsoft Date and Time Picker Control 6.0 (SP6), click OK:ģ. Go to File > Options >Customize Ribbon, check Developer to show the Developer tab on the ribbon:Ģ. You can download Microsoft Windows Common Controls 6.0 from this link: But the requirement didn't tell us if Office 2016 can use it. There was a MonthView control available before. ActiveX objects are to be displayed in UserForm. These files contain a VBA application which utilizes a couple of ActiveX control objects from mscomct2.ocx library (namely, MonthView and DateTimePicker).
Hello, I'm trying to insert a Calendar control into a spreadsheet so that I don't have to type the dates. We are using a set of Excel files on several machines in our company. If your Excel is 32-bit, please take the following steps to insert a calendar:ġ. Windos10 - Office 365 - Excel - MonthView Control. If you are using the 64 bit version of Office, I am afraid there is no official date picker control What's the version of your Excel 2016, 32-bit or 64-bit? Please go to File > Account > About Excel to have a check.Īs far as I know, Microsoft's Date Picker control works with 32-bit versions of Excel 2016, Excel 2013, and Excel 2010, but it will not work on Excel 64-bit.
