一、日期控件 日期选择器DTPicker 添加DTPicker控件 在工具箱-附加控件,找到Microsoft Date and Time Picker Control,version 6.0,点击“确认”就能添加到工具箱里。 如果没找到的话,需要安装对应系统位数的微软通用控件MSCOMCT2.OCX(具体操作可自行百度)。 点击下拉按钮,在日期列表中选择需要
在工具箱-附加控件中找Microsoft date and time picker control,如果没有就是需要去下载一个文件MSCOMCT2.OCX 文件地址:mscomct2.ocx下载-mscomct2.ocx官方版下载[ActiveX插件]-华军软件园 (onlinedown.net) 下载压缩后,根据自己windows的版本是64位,所以将文件放置在C:WindowsSysWOW64下, 然后按win+R运行,输入cmd...
待有一定的机会会出书,让大家看到一个实实在在的VBA,今日的讲解用到的控件是DTP控件,是日期时间控件Microsoft Date and Time Picker Control 6.0,的简称。在工作表中单击菜单“开发工具”→“插入”→“控件工具箱”,选择“其他控件”中的DTP控件如下图所示,就可以在工作表中添加一个DTP控件。在设计模式下...
2 单击菜单中的“工具”→“附加控件”,在弹出的“附加控件”对话框中拖动右边的滚动条直至找到并选中“Microsoft Date And Time Picker Control”,然后单击确定。如下图所示:3 拖动“工具箱”中右边的上下滚动条,将可以看到新添加的日历控件,单击日历控件,即可将日历控件插入到用户窗体中。如下图所示 ...
to overcome the monstrosity that is the Microsoft MonthView control. If you're reading this, you probably already know what I'm talking about. Many others have been in my place and have come up with their own date pickers to solve this problem. So why yet another custom date picker?I...
在引用的过程中我是先直接浏览找到我第一步安装的插件C:\Windows\SysWOW64\MSCOMCT2.OCX,再去找到的Controls-2 6.0第三步:添加控件,找到Microsoft Date and Time Picker Control,verion 6.0,这里简称DTP吧,并点击它,使他变成选中状态“☒”,这里你看再看看控件工具箱上是不是多了个控件,没错就是DTP...
In that case, You need to develop your own Date Picker or you can use any third party Date Picker Control compatible with 64 bit version. Other thing you had mentioned in your original post ,"Extract mscomct2.ocx from MSCOMCT2.CAB to C:\windows\system32 (windows 32 OS) or C:\windows...
Hi all, I am trying to get the Date and Time Picker control(DTp) in my userform. It doesn't show in the list. After a few researches and going through some...
Hi Everyone, I'm trying to make a userform in Excel VBA. I need to add a date picker. But that isn't available in the list of available tools (Not in...
一、My97DatePicker当前最新版本: 4.8 1. 使用说明: My97DatePicker目录是一个整体,不可破坏里面的目录结构,也不可对里面的文件改名,可以改目录名 My97DatePicker.htm是必须文件,不可删除(4.8以后不存在此文件) 各目录及文件的用途: WdatePicker.js 配置文件,在调用的地方仅需使用该文件(其它的文件可自动引入),可多...