- Microsoft Date And Time Picker Control 6.0 Sp6 Manual
- Microsoft Date And Time Picker Control 6.0 (sp6) Excel 2019 Download
- Microsoft Date And Time Picker Control 6.0 (sp6) Not In Excel
If you've attended one of our Excel VBA training courses you might remember using the Date and Time Picker control when building a user form.
The Date and Time Picker is a.NET 2.0 Windows Forms control that works on Forms and DataGridViews. I can display a Date, a Time, or both in one control and can be bound to a database value. Microsoft Date and Time Picker Control 6.0 (SP6) merupakan salah satu element yang menarik untuk memunculkan PopUp kalender Date and Time Picker. Namun dibeberapa windows dan Microsoft Office Microsoft Date and Time Picker Control 6.0 (SP6) yang dibutuhkan malah tidak ada. Step 3: Select 'Microsoft Date and Time Picker Control 6.0 (SP6)' from the list; Step 4: Click 'OK' at the bottom. You will notice the mouse cursor is changed to a small black cross '+'. Draw a square or click anywhere in the worksheet, and a box with date will appear. At the same time, the EMBED formula will also show up in the formula bar.
An exciting shot of the Date and Time Picker in action. As its name suggests, it allows a user to pick a date and time value rather than having to type it in.
The Date and Time Picker is immensely useful when designing VBA user forms but, sadly, it isn't included with every version of Windows. I discovered this recently when moving to a new machine with a 64bit edition of Windows 7 installed. Fortunately, it is relatively simple to install the Date and Time Picker, as long as you don't mind getting your hands dirty with a couple of simple command line instructions.
Downloading the Files You'll Need
The Date and Time Picker is part of a library of tools with the catchy title of MSCOMCT2.OCX. To start with, you'll need to download this file from the Microsoft support site.
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 brief bit of Googling.
When you've clicked the link to start downloading the file, choose to save it somewhere on your computer.
Click the Save as option so that you can choose where to save the file.
On the next dialog box choose a location on your computer and then click Save to download the file.
Extracting the Downloaded File
Once it's finished downloading you'll need to extract the file. Start by double-clicking on the file that you've downloaded.
Double-click the .cab file to see what it contains.
Once inside the .cab file you can choose to extract the .ocx file by right-clicking on it and choosing Extract...
Right-click the file called mscomct2.ocx and choose to extract it.
Choose which folder you want to extract the file to and click Extract.
Select an existing folder, or create a new one, and then click Extract.
Copying the File to the Correct Folder
In order to make use of the file you've downloaded you'll need to place it in the correct folder for the edition of Windows that you're using. Start by opening a Windows Explorer window and browsing to the Windows installation folder. On my machine this is C:Windows.
The next folder you need to browse to depends on which edition of Windows you're using. If you're using a 32bit edition you'll need the System32 folder. If you're using a 64bit edition, like I am, you'll need SysWOW64.
Once you've navigated to the correct folder, simply move or copy the MSCOMCT2.OCX file into it.
The file now sits in the correct folder.
Registering the File
Before you can make use of the file you'll need to register it. You can do this using the command line tool in Windows. Go to the Start menu and in the search box type cmd.
Type cmd into the search box at the bottom of the Start menu.
Still in the Start menu, right-click on the cmd.exe item which appears and choose to run it as an adminstrator.
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 you copied the file into earlier.
If I was running a 32bit edition of 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 one shown below. Of course, you'll need to use the directory relevant to your own Windows installation.
Microsoft Date And Time Picker Control 6.0 Sp6 Manual
Press Enter at the end of the line to change the directory.
Once you've changed the directory you can write one final command to register the file on your machine.
For reference, the command is regsvr32 mscomct2.ocx
If everything works normally you should see a message similar to the one shown below:
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.0.
You'll find that you have access to several other controls from the mscomct2.ocx library as well.
Have you ever wanted a calendar to show next years date? It’s easy and convenient in most of the cases.
Microsoft Date And Time Picker Control 6.0 (sp6) Excel 2019 Download
It can be a headache to maintain the data integrity when you are working with bigger and shared Excel worksheets. Especially, entering dates can become a nasty work. It always confuses the people if they should be mm/dd/yy or dd/mm/yy or mm-dd-yyyy? Or can you type a date like “10 Oct 2018”? Oh, and what would be the date of the third Friday in October this year?
Adding a drop down calendar in your excel sheet can solve these problems. A drop down calendar allows your users to fill the dates on a click of mouse. This guide shows you a trick that might work for you and save you tons of your time.
Before we start, you have to make sure the developer tab is available. If the developer tab is not already available in your Excel ribbons, you can follow these steps.
The first thing you need to do is click on the file in the top left of your screen and select “Options” at the very bottom of it.
Microsoft Date And Time Picker Control 6.0 (sp6) Not In Excel
This opens a new “Excel Options” box with bunch of options to select. Now click on “Customize Ribbon” which will bring out some more settings.
You should check the “Developer” option in the right hand box, under main tabs.
TADA! Now you have developer tab in your Excel ribbons. This is where all the magic is going to happen.
Now that you have the developer tab, let’s jump right into creating calendar and using it as a date picker.
In the developer tab, click on insert and go to the very bottom, where it says more controls. More controls allow you to insert a control from the set of controls available on your computer. The control we are going to use is available by default.
Once you click the more controls it open a new box with a list of options. In the list, scroll down the Microsoft date and time picker and select it.
Now you need to place the calendar somewhere on the screen. So select some part on your excel sheet and place it.
In the next step, turn off the design mode under developer tab. Now when you click on the little arrow it will bring out the calendar.
If you want to use calendar as a date picker you need to take a few more steps. Don’t worry we are almost there.
Now, turn back the design mode on again and click properties under developer tab. Under the properties click on LinkedCell and enter the cell number of your date. In my case which is B2.
Once you have assigned the date cell, turn off the design mode off again.
Now when as you pick the date from calendar it changes the date in your assigned cell.
This way you can share your excel sheet with other users and they can pick a date from calendar to fill the dates.