vba 适用于 Excel 2010/2007/2003 的日期选择器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12499760/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
datepicker that works for Excel 2010/2007/2003
提问by user175084
I need a datepicker in VBA for Excel.
我需要一个用于 Excel 的 VBA 中的日期选择器。
I had run into this issue because Excel 2010 64 bit does not have a datepicker, which worked fine in Excel 2007/2003.
我遇到了这个问题，因为 Excel 2010 64 位没有日期选择器，它在 Excel 2007/2003 中运行良好。
I am looking for a free control which can be used for commercial purposes.
我正在寻找可用于商业目的的免费控件。
Any help will be appreciated.
任何帮助将不胜感激。
Thanks
谢谢
回答by MGM
We have created a VBA solution, what fully compatible with the old MSCAL.OCX, but you need no ActicveX install to use it:
我们创建了一个 VBA 解决方案，它与旧的 MSCAL.OCX 完全兼容，但您无需安装 ActiveX 即可使用它：
https://sites.google.com/site/e90e50/calendar-control-class
https://sites.google.com/site/e90e50/calendar-control-class
It works in all Excel (Access, etc.) versions too. :)
它也适用于所有 Excel（Access 等）版本。:)
Best Regards,
Axelock
最好的问候，
Axelock
回答by spences10
I have come across this issue many times in the past and the only sure fire way to circumvent it is to make a custom calendar control in VBA
过去我多次遇到过这个问题，唯一确定的绕过它的方法是在 VBA 中制作自定义日历控件
Here is the one I use created by a colleague of mine back in 2009 http://goo.gl/hyhIh
这是我在 2009 年使用的一个同事创建的http://goo.gl/hyhIh
It does the job very well, I have adapted my own one in several MS Access projects in the past feel free to use for your own purposes
它的工作非常好，过去我已经在几个 MS Access 项目中改编了自己的一个，可以随意用于自己的目的
