In the right-hand corner of Insert drop-down list click More Controls button and find the Date and Time Picker Control then add it. Per Drowdown lässt sich mit dem Date and Time Picker Control-Element komfortabel ein Datum auswählen und in eine verbundende Zelle eingeben. The nice thing about the Date and Time Picker is that you can provide a date input field with little effort which always delivers a date as the result. Select Microsoft Date and Time Control from the list - OK - After clicking on OK drag directly on the sheet to add the control. In earlier versions of Excel the Date and Time Picker Control mscomct2ocx in Excel 20 and mscalocx in Excel 2007 was usually included with the default installation. Excel 2010 Developer tabe Insert ActiveX bottom right More MIcrosoft Date and Time Picker SP4. The Date and Time Picker Control is available only in the 32bit version of Excel but its hidden. Calendar control is removed in Access 2010 and is not usable for Excel 2010.
Microsoft discontinued the legacy 32-bit calendar control MSCALOCX in Excel 2010 and replaced it with the new 32-bit Date Picker contained in Active-X library member mscomct2ocx. Youll find that you have access to several other controls from the mscomct2ocx library as well. The control element Microsoft MonthView Control 60 SP4 can also not be found under other controls. The users of Excel 2016 will have to download and register this control manually. Vba Controls Datetimepicker Your best options are to create your own ActiveX Control by wrapping the Date And Time Picker Control fromNet or communicate using COM and expose the features that you want or use one of the custom VBA solutions that can be found on Ron de Bruins CalendarDate Picker page.ĭate and time picker control excel 2010. Date Picker for Excel inserts a pop-up calendar into Microsoft Excel. This app requires the desktop version of Microsoft Excel.
0 kommentar(er)
