Jan
6
Daniel Curran on January 6th, 2009
(16 votes, average: 4.00 out of 6)
Loading ...
(16 votes, average: 4.00 out of 6) Loading ...In the posting “Insert a Drop Down Calendar Menu In Excel – Choose a Date!” one of the steps requires that you select the Microsoft Date & Time Picker Control 6.0 (SP4).
Looking for it? Trying to figure out where to download it from? If it is not installed on your system you can download it here.
To unzip a CAB file simply follow the directions in the posting “A Free Alternative to Winzip or WinRar: 7-Zip”
Once the file is unzipped simply run the MSCOMCT2.BAT batch file!
February 23rd, 2009 at 9:02 am
I have developed a worksheet for my department and it includes the use of Microsoft Date and Time Picker Control 6.0 as part of a UserForm. When I distributed the worksheet, a few employees have had the debugger come up when the UserForm appears because their version of excel does not have the Microsoft Date and Time Picker as an option under "Additional Controls…" on the toolbox pulldown. I tried installing the Picker using your instructions above but all that happened was it ran a command box for a split second and then nothing happened. Any suggestions? Some Microsoft Excel 2003 users have the control, others do not. Can the problem be resolved through a service pack download or some sort of Microsoft update? Or perhaps you may know what I am doing wrong when I tried running the above download. Any ideas would be appreciated!
Thanks, Ian
March 11th, 2009 at 1:41 pm
Ian, did you run it as the local administrator?
March 17th, 2009 at 11:47 am
Exactly what I was looking for. Thanks!
April 9th, 2009 at 1:40 am
Unzipped the file and ran the batch file but said "Access is Denied". Tried running as Administrator too and that didn't do anything different
May 7th, 2009 at 10:49 am
THANKS.
August 21st, 2009 at 6:28 am
Hi
Can I put date and hour together? is there this resource in microsoft date and time picker 6.0
January 17th, 2010 at 8:33 pm
I tried to follow the above steps to insert a drop down calendar to pick a date, however after I make the box for the date to appear, it says cannot insert object. Pls. help.
January 22nd, 2010 at 4:18 am
Hi i ran the bat file but nothing happens. The dos window opens up and closes within a sec… Ur reply is very important.. please anyone help
February 8th, 2010 at 11:56 pm
Hi, I am also facing the same issue of "cannot insert object" even after appying the same method as given above.Help appreciated
Piyusha
February 11th, 2010 at 7:03 am
Thank this actually helps after installing SP4
February 18th, 2010 at 7:12 pm
This doesn’t work. I get the same problem as Ian and Mary. Command window pops up for a split second, then closes.
February 18th, 2010 at 7:13 pm
This doesn't work. I get the same thing as Mary and Ian. Command window opens up for a split second then closes.
February 26th, 2010 at 11:30 am
Worked like a charm. Only wish there was an easier way to get a colum of these dates without copying and pasting the control over and over again and changing the linked cell for each one.
March 29th, 2010 at 7:09 pm
I actually unzip "Microsoft Date & Time Picker Control 6.0 (SP4)" but still cant run" MSCOMCT2.BAT "
July 30th, 2010 at 7:13 am
Copy both the .bat file and the .OCX file to your desktop. Copy the MSCOMCT2.OCX to your system32 folder, then run the batch file "as administrator". Reopen excel and check controls. And there it was. Works great. Wish I could blank it out but looks like there has to be a date in there after you select an initial date.
September 1st, 2010 at 11:08 am
McCoy
Thank you so much for your help
It really works great