今天在一台虚拟机上面,打开一份Excel表格,无法显示里面的日期控件,检查了一下,发现是Excel里面没有注册Microsoft Date and Time Picker Control 6.0(SP6)控件。后来通过下载控件手动注册后解决问题。 做个记录,以免遗忘。 操作系统:Windows Server 2008 R2
Dear guys, The Microsoft Date and Time Picker Control 6.0 (SP6) not listed in the "More Control" list .. and I'm not able to use the datepicker control. I'm using Excel 2010 (32-bit) running on windows 10 (64-bit) Would you please help me on that?
I tested in my current Excel 2013 (32-bit) and Windows 10 (64-bit) by following the detailed instructions in the article below and the control can be registered properly: https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/#Register-date-picker ...
在"插入活动控件"对话框中,向下滚动以查找 Microsoft Date and Time Picker Control 6.0 (SP4)(您计算机上的该控件可能具有更新的 SP,如 SP6),然后单击"确定"以插入该控件(见图 4)。请注意,您的可用控件列表可能与此图不符。 图4. Microsoft Date and Time Picker 控件 选择该控件会在当前窗体中插入实例。...
I'm looking to add the Microsoft Time and Date Picker Control in Excel 2016, as was possible in earlier versions. In Office 2013, you had to download and register the Microsoft Windows Common Controls 6.0 (SP6) to access this feature, but now I can't find it anywhere. Several places ha...
Based on your description, do you mean the Microsoft Date and Time Picker Control 6.0 (SP6) is not listed in your More Controls list? Would you please provide the detailed error message then we can help you better? What's the version of your Excel? Please go to File > Account > About...
I ended up usingMicrosoft Date and Time Picker Control 6.0 (SP6).This worked like a charm in providing a date, Format1 - dtpShortDate, and a time, Format2 - dtpTime Wednesday, February 24, 2016 3:15 AM Hi, ITBobbyP According to your description, as far as I know that SEP date ...
Can not find hidden control in form designer Can't access controls on code behind - what am I doing wrong? Can't Close A Form in C# Can't disable a button Can't Edit form1[design] can't remove or stretch background image...
Form Object Anchoring and Resizing Date Picker Web Browser Control Edge Browser Control Image Control with Control Source Split Forms Navigation Forms Image Gallery (Shared Resources) Modern Charts more Property Sheet sorting Enhanced Zoom Box Add Tables Task Pane Highlighted Active Tab...
In theInsert Active Controldialog box, scroll down to find Microsoft Date and Time Picker Control 6.0 (SP4) (the control on your computer might have a later SP such as SP6), and then clickOKto insert the control (see Figure 4). Be aware that your list of available controls may not ma...