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. ...
1. 打开Excel文件,点击菜单栏上的“开发工具”选项卡。如果您的菜单栏上没有该选项卡,需要先启用开发工具选项卡。 2. 在“开发工具”选项卡中,点击“插入”下方的“更多控件”按钮。 3. 在弹出的“控件”对话框中,选择“Microsoft date and time picker control”(Microsoft日期和时间选择控件)。 4. 点击“确...
I have got a new pc at work with (probably) other version of Office (365 Pro Plus), and, in older excell sheets I have created I am not able any more to see Date and Time picker in Developer tab. It is not even showing there. ...
Suppose you must use an Excel Date Picker in a 64-bit edition of Microsoft Excel. In that case, you can employ Randy’s alternate popup date picker solution atExcel for Freelancersto show a cell value on a calendar in Excel. Select a date like today’s Date from a popup calendar box ...
在工具栏上右单击鼠标，选择附加控件，在弹出的窗口里找到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:...
Re: [RESOLVED] [Excel] Microsoft Date and Time Picker Control 6.0 (SP6) not listed Shehata Regarding your image .. 2 questions 1. How did you get the selected col-row (K and 7) to have a backcolor of gold? 2. I can click the Design Mode (mine is grey, no...
You can easily update the date/time format for a whole column in Excel 365. Here is how you can do it: Select the entire column containing the date/time values. You can click on the column header to select the entire column. Right-click on the selected column and choose "Format ...
大神求助注册使用mi..大神求助注册使用microsoft date and time picker control控件,环境为WIN7 64位 OFFICE 2010 64位,在SYSTEM32和SYSWOW64下注册均成