1. 打开Excel文件,点击菜单栏上的“开发工具”选项卡。如果您的菜单栏上没有该选项卡,需要先启用开发工具选项卡。 2. 在“开发工具”选项卡中,点击“插入”下方的“更多控件”按钮。 3. 在弹出的“控件”对话框中,选择“Microsoft date and time picker control”(Microsoft日期和时间选择控件)。 4. 点击“确...
Hello , I would like to add date picker on an excel sheet. The goal is to create an excel file and have this sent to users to fill in. When filling the excel, and click on the start date, a cal...Show More admin BI & Data Analysis developer excel Excel for web Formulas and Fun...
I would like to add date picker on an excel sheet. The goal is to create an excel file and have this sent to users to fill in. When filling the excel, and click on the start date, a calendar dropdown should appear and users select the date from the calendar so as to eliminate dif...
确认注册成功。打开EXCEL,选择"文件“-”选项“,在Excel选项中选择”自定义功能区“,选择” 开发工具“选项框。 点击Excel菜单中的“开发工具选项卡”,点击插入“其他控件” 在其他控件中选择,Microsoft Date and Time Picker Control控件 现在就可以在EXCEL中使用日期控件了。 设计日期的选择界面,在日历的控件按鼠标...
I held off a long time before I installed the 64 bit version of Excel on one of my workstations. Is there still no Date Picker for VBA to call? Regards, Rich Locus, Logicwurks, LLC http://www.logicwurks.com All replies (3) ...
在工具栏上右单击鼠标，选择附加控件，在弹出的窗口里找到microsoft date and time picker control，单击前的方框选定它，然后确定。如果你没有找到它，可以先去下载mscomct2.ocx，然后复制到windows\system32下并用regsvr32注册。
I am currently trying to use the Microsoft Date and Time picker for a project in Excel 365 64-Bit, Windows 7 64-Bit. These are the steps I have performed. Obtained the mscomct2.ocx file, placed it in C:\syswow64 folder and used regsvr32 to successfully register it. ...
Microsoft.Office.Tools.Excel.Controls.DateTimePicker 有其他一些成员,通过这些成员可将其添加到 Excel 工作表,而且这些成员为其提供了额外的方法和属性。不要使用 New 构造函数创建新的 DateTimePicker。 使用 AddDateTimePicker() 方法可将新的 DateTimePicker 添加到工作表中。
进入VBA编辑器，工具菜单，引用；在引用窗口中点击浏览按钮，并找到你的MSCOMCT2.OCX，确认后，确定在引用中勾选了Microsoft Windows Common Controls-2xx。确定后，就可在控件列表中找到日期时间提取控件了
It is bacause AxctiveX for DateTimePicker control has not been installed. To install it, please refer to: https://social.msdn.microsoft.com/Forums/vstudio/en-US/b6f8832d-5ad7-4192-bc72-b3b6fdcc46ee/datepicker-in-excel-2013-32-bit-running-on-win-81-64-bit?forum=exceldev ...