Saturday, November 26, 2011

How to Add the Microsoft Date amp; Time Picker in Excel 2007


1. Download Microsoft Windows Common Controls-2 6.0 from the Microsoft website.
2. Extract the .cab file's contents. Newer Windows versions open .cab files directly. Older versions need extraction software such as WinZip or WinRAR.
3. Run the 'mscomct2.bat' file. This installs the Microsoft Date & Time Picker.
4. In Excel, click the Office button on the screen's top left corner. Select 'Excel Options.' The 'Excel Options' window will open.
5. Click 'Popular' from the top of the left column.
6. Check the box next to 'Show Developer tab in the Ribbon.' Close the window. Excel's ribbon now contains the Developer tab to the far right.
7. Click on the Developer tab to show its controls. Click the 'Insert' button, and select the bottom right icon, which shows additional ActiveX controls. The 'More Controls' window will open.
8. Choose 'Microsoft Date and Time Picker Control 6.0 (SP4)' and close the window. Your mouse cursor will turn into cross hairs.
9. Click and drag anywhere on your spreadsheet to create a date box.