1. 打开Excel文件,点击菜单栏上的“开发工具”选项卡。如果您的菜单栏上没有该选项卡,需要先启用开发工具选项卡。 2. 在“开发工具”选项卡中,点击“插入”下方的“更多控件”按钮。 3. 在弹出的“控件”对话框中,选择“Microsoft date and time picker control”(Microsoft日期和时间选择控件)。 4. 点击“确...
在Excel中, 开发工具,点击更多控件: 插入Date and Time Picker. Regards, Winnie Liang Please remember tomark the replies as an answersif they help andunmarkthem if they provide no help. If you have feedback for TechNet Subscriber Support, contacttnmff@microsoft.com. 2017年7月28日星期五 上午2:...
在工具栏上右单击鼠标，选择附加控件，在弹出的窗口里找到microsoft date and time picker control，单击前的方框选定它，然后确定。如果你没有找到它，可以先去下载mscomct2.ocx，然后复制到windows\system32下并用regsvr32注册。
在Excel 2013的开发工具中如果未能找到微软的日期控件Microsoft Date And Time Picker Control,这就需要手工进行相关的注册。下面介绍下相关的注册该控件的方法。 点击开始菜单,以管理员的身份运行CMD,打开Windows的命令窗口。 如果是32位版本的Windows,进入 C:\Windows\System32 目录 如果是64位版本的Windows,进入 C:...
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. Even if you add a reference to mscomct2.ocx...
今天在一台虚拟机上面,打开一份Excel表格,无法显示里面的日期控件,检查了一下,发现是Excel里面没有注册Microsoft Date and Time Picker Control 6.0(SP6)控件。后来通过下载控件手动注册后解决问题。 做个记录,以免遗忘。 操作系统:Windows Server 2008 R2
工程->部件->控件->Microsoft Windows Common Controls-2.6 选中就有microsoft date and time picker control 控件了的 还有一种，直接在工具栏，右键，添加控件，->Microsoft Windows Common Controls-2.6 选中就有microsoft date and time picker control ...
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?
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. Even if you add a reference to mscomct2.o...