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. ...
确认注册成功。打开EXCEL,选择"文件“-”选项“,在Excel选项中选择”自定义功能区“,选择” 开发工具“选项框。 点击Excel菜单中的“开发工具选项卡”,点击插入“其他控件” 在其他控件中选择,Microsoft Date and Time Picker Control控件 现在就可以在EXCEL中使用日期控件了。 设计日期的选择界面,在日历的控件按鼠标...
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 date and time picker control，单击前的方框选定它，然后确定。如果你没有找到它，可以先去下载mscomct2.ocx，然后复制到windows\system32下并用regsvr32注册。2003
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...
From the ribbon you can launch the date picker, or quickly insert the date / time, and customize how you want the picker to work. Download nowfor Excel! How to install: View instructionsfor how to enable VBA and install the add-in after downloading!
2 年前· 来自专栏 EXCEL VBA 行走中的菜鸟 松弛的琴弦,永远奏不出时代的强音。没有礁石,就没有美丽的浪花关注在工具箱-附加控件中找Microsoft date and time picker control,如果没有就是需要去下载一个文件MSCOMCT2.OCX 文件地址:mscomct2.ocx下载-mscomct2.ocx官方版下载[ActiveX插件]-华军软件园 (onlinedown...
进入VBA编辑器，工具菜单，引用；在引用窗口中点击浏览按钮，并找到你的MSCOMCT2.OCX，确认后，确定在引用中勾选了Microsoft Windows Common Controls-2xx。确定后，就可在控件列表中找到日期时间提取控件了
{"__typename":"ForumTopicMessage","uid":3159975,"subject":"Date & Time Picker","id":"message:3159975","revisionNum":1,"repliesCount":0,"author":{"__ref":"User:user:1305913"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref"...