Installing the Date and Time Picker Control for VBAIf youve attended one of our Excel VBA training courses you might remember. Date and Time Picker control when building a user form. An exciting shot of the Date and Time Picker in action. As its name suggests, it allows a user to pick a. The Date and Time Picker is immensely useful when designing VBA user forms but. Windows.   I discovered this. Windows 7. installed. Fortunately, it is relatively simple to install the Date and. Time Picker, as long as you dont mind getting your hands dirty with a couple of. Downloading the Files Youll Need. The Date and Time Picker is part of a library of tools with the catchy title. SubInACL is a commandline tool that enables administrators to obtain security information about files, registry keys, and services, and transfer this. MSCOMCT2. OCX.   To start with, youll need to download. Microsoft. Click this link on the page to start downloading the file. UPDATE Sadly, Microsoft have since removed this file from their site. You can. still download it from a variety of third party sites which you can find with a. Googling. When youve clicked the link to start downloading the file, choose to save it. Click the Save as option so that you can choose. On the next dialog box. Save to. download the file. Extracting the Downloaded File. Once its finished downloading youll need to extract the file. Start. Some versions of Windows dont include the very useful Date and Time Picker control. This blog explains how to install the mscomct2. How to Install Microsoft Date Time Picker Control 6. Blacksite Area 51 Full Game. SP4 In the posting Insert a Drop Down Calendar Menu In Excel Choose a Date one of the steps. Bonjour, jutilise un fichier cre par quelquun dautre et lorsque je louvre Excel me met Impossible de charger le objet car il nest pas. Mscomct2 Cab Installation' title='Mscomct2 Cab Installation' />Double click the. Once inside the. Extract. Right click the file called mscomct. Choose which folder you want to extract the file to. Extract. Select an existing folder, or create a new one. Extract. Copying the File to the Correct Folder. Digital Hotcakes Wedding Essentials Vol 3 here. In order to make use of the file youve downloaded youll need to place it in. Windows that youre using. Start by. Windows Explorer window and browsing to the Windows installation. On my machine this is C Windows. The next folder you need to browse to depends on. Windows youre using. If youre. using a 3. System. 32 folder. If youre using a. I am, youll need. Sys. WOW6. 4. Once youve navigated to the correct folder, simply. MSCOMCT2. OCX file into it. The file now sits in the correct folder. Registering the File. Before you can make use of the file youll need to register it. You can. Windows. Go to the Start menu and. Type. cmd into the search box at the bottom of the Start menu. Still in the Start menu, right click on the cmd. Right click on the icon and choose. Run as administrator. At the command prompt make sure that the directory shown is the same as the one. If I was running a 3. Windows 7 this would be pointing to the correct folder. If you need to change the directory you can do so using a command similar to the. Of course, youll need to use the directory relevant to your. Windows installation. Press Enter at the end of the line to change the directory. Once youve changed the directory you can write one final command to register. For reference, the command is. If everything. works normally you should see a message similar to the one shown below Success Using the Date and Time Picker. You should now find that you can use the Date and Time Picker control in your. VBA forms. In the design view of a VBA form, right click on the Toolbox and choose. Additional Controls. On the dialog box which appears, check the box next to the entry for the. Microsoft Date and Time Picker Control 6. Youll find that you have access to several other controls from the.