iopsexy.blogg.se

Create a drop down calendar in excel 2013
Create a drop down calendar in excel 2013











However, I found that it didn't work in Excel for Office 365 and 64-bit Then, I could open it in Excel 2016 and Office 2019(VL, 32-bit edition) and pick a date to update the control.

create a drop down calendar in excel 2013

Microsoft does not guarantee the accuracy of this information.īased on my tests, I created a date control in Excel 2010 and save it. Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. To create calendar in Excel (drop-down and printable). For more information, you can read the 3rd-party article: How You add a reference to mscomct2.ocx/mscal.ocx in Excel 64 bit, it will still return the "Could not load an object because it is not available on this machine" error. As far as I know, Microsoft Date and Time Picker Control 6.0 is an old control and it has been removed from Office since Office 2016. Although you can register the calendar control for Windows 64 bit, it will work for Office 32 bit only.













Create a drop down calendar in excel 2013