问题描述
我正在尝试将日历选择添加到我使用MS Excel 2013创建的表单中,但我没有日期选项和开发人员选项卡下的时间选择器。它只是不存在。我已经看到了工作,但我担心我会损坏计算机上的
。有谁知道我是否可以使用VB来解决这个问题?我似乎不知道为什么这很困难,因为很多人都想使用这个功能。
I am trying to add a calendar selection to a form I am creating at work using MS Excel 2013 but I don't have the option for date and time picker under the developer tab. It just doesn't exist. I have seen the work around but I am worried I will damage something on the computer. Does anyone know if I can use VB to fix this issue? I just don't know why this is so difficult when it seems like many people want to use this feature.
谢谢
推荐答案
您的意思是excel中日历控件的解决方法是注册该控件。 (MSCOMCT2.OCX)
Do you mean the workaround of the calendar control in excel is register that control. (MSCOMCT2.OCX)
据我所知,我们无法通过VBA解决这个问题。我们可以通过VBA自己实现该功能(例如,在用户表单中使用自定义逻辑),但这可能并不容易。
As far as I know, we can‘t fix that issue through VBA. We could achieve that feature by ourselves through VBA (e.g. do it with custom logic in a userform), but it may not easy.
您可以提交反馈:
http://office.microsoft.com/en-US/suggestions.aspx?origin= RZ010243529& CTT = 114 ,在您提交反馈后,请在此处发布链接,这可能会使有类似问题的其他人受益。
You may submit the feedback: http://office.microsoft.com/en-US/suggestions.aspx?origin=RZ010243529&CTT=114, after you submit the feedback, please post the link here, which may benefit others who has similar issue.
最好的问候
Starain
这篇关于Microsoft日期和时间选择器控件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!