2020. 2. 14. 21:23ㆍ카테고리 없음
I'm going to make the assumption you're using add-in.If that's the case, the installation is fairly easy. It depends on what OS you're using, though.Here's what the website states:1) Download the RDB Date Picker add-in.2) Copy WinDatePicker.xlam to a unprotected directory on your system.3) Start Excel and open a workbook.2007: Click the Microsoft Office Button, click Excel Options, click the Add-Ins tab.2010-2016: Click on File, click on Options, click the Add-ins tab.In the Manage drop-down, choose Excel Add-ins, and click Go. Use 'Browse' to select the add-in and then click on OK.
Verify that the Date Picker is checked in the add-in list and then click OK.4) Right click on a worksheet cell and choose Date Picker to open the user form.That should work, if not, please tell me. Also, tell me if you used another date picker.
Ed has three computers at work. One has Excel 2010 with the Date Picker tool but the other two, one with Excel 2010 and one with Excel 2013, do not have this tool available. He wonders how he can load this tool into Excel 2010 and Excel 2013.According to reports from Microsoft, the traditional date picker tool (called MSCAL.OCX) was shipped with Office 2007, but is not included in later versions of Office. In Office 2010 they have replaced the date picker with an updated version in the Active-X library, called MSCOMCT2.OCX.You can tell if you already have the new date picker installed by following these steps:.
Display the of the ribbon. Click the Insert tool. Excel displays a palette of tools you can insert in your worksheet. In the ActiveX Controls section of the palette, click the More Controls option. (It is the very bottom-right tool.) Excel displays the More Controls dialog box. Scroll through the dialog box until you find the Microsoft Date and Time Picker tool. Select it.
Microsoft Excel Date Picker Control
Sep 04, 2018 Download Microsoft Date And Time Picker Control Excel Source: www.gmayor.com. Use the slides to supply details about what it is you’re delivering, but make sure the info is crystal clear and concise. It is going to also create the information a lot simpler to understand for your audience. Microsoft Date And Time Picker Control Excel Download.
Click OK.If the tool doesn't show up in the More Controls dialog box, then it has not been installed on your system. If you are using a 64-bit version of Office, then you won't be able to install the control. The reason is because MSCOMCT2.OCX works only on 32-bit systems. (In fact, none of the ActiveX controls work in 64-bit Office.
When Microsoft actually comes out with versions of the controls that do work with 64-bit Office, they will likely have different names, a move sure to complicate the life of VBA programmers who rely on the controls.If you are running a 32-bit version of Office, then you can try to copy the MSCOMCT2.OCX control from a like system and register it with Windows. (Before copying it, do a Windows search to see if the file is actually on your system. If it is, skip copying and just try to register it.)How you register the control depends on the version of Windows you are using and whether you are using a 32-bit or 64-bit version of the operating system. (Don't confuse the number of bits in the operating system with the number of bits in your copy of Office; they are two different things.) A good overview of how to register the control can be found here. Date Picker Alternatives For 64-Bit Office: Several 'private' solutions have been posted on varoius forms.
These are not official Microsoft solutions, but users of the 64-bit systems said they worked:you want to stay with Microsoft offerings and you are running Office 32 bit, then keep reading the article below.Important Note: The Active-X Date Picker can be registered for Office 2010 32-bit, but it will not work on Office 2010-64-bit. Developers who use the Date Picker are advised to stay with the 32-bit version of Office 2010. There is no official replacement for the much-loved date picker in the 64-bit version of Office 2010, as shown in the following article and forum post by Microsoft:Date Picker 2015 Fixes For Active-X IssuesNo Formal Date Picker For Office 2010-64bit As Of July 2012. The 4-headed cursor shows you are still in 'Design Mode'. So right-click the mouse, and select the option 'View code'.You should see something like this in the VBA editor window:Private Sub MonthView21DateClick(ByVal DateClicked As Date)End Subadd a line so that it looks like this:Private Sub MonthView21DateClick(ByVal DateClicked As Date)activecell.value = DateClickedEnd SubNow return to the worksheet (press AltF11 ). Come out of 'Design Mode' by clicking 'Design Mode' in the top-panel Ribbon on the 'Developer' tab.If you can't see the 'Developer' tab in the top-panel Ribbon, do this:Go back to the VBA Editor AltF11Go to Immediate Window CtrlGenter this line, and then press EnterApplication.ShowDevTools=TrueReturn to Excel worksheet AltF11Come out of 'Design Mode' by clicking 'Design Mode' in the top-panel Ribbon on the 'Developer' tab.Now, put cellpointer in any cell, then click a date on the Calendar.
It will be placed into the active cell. If it shows as ####### just make the column wider to show the date.That's it.