Ask a new question

Date picker dropdown in Excel 2013

Hi, 

 

I have looked for support of inserting a date picker drop down into a cell.  The only instructions available are for Office 2010 or previous;  these instructions seem to be the most comprehensive, but they are referring to Excel 2010 ...upon review, the file is not contained in my C:\Windows\SysWoW64. 

 

Extract from website - instructions

If you are using Office 2010 32-bit, then the following procedures will work.
If the date picker library is not already registered, then :

FOR 64-BIT WINDOWS 7, HERE'S HOW:

(1) Perform the function below on any computer that is missing the mscomct2.ocx.
(2) Make sure a copy is in C:\Windows\SysWoW64
(3) Click the Windows 7 Start Button and in the Search area, type "command"
(4) The search will bring up a number of items, including "Command Prompt" at the top
(5) Right click the "Command Prompt" banner, and select "Run as Administrator"
(6) At the command prompt, enter: %systemroot%\SysWoW64\regsvr32.exe mscomct2.ocx
(7) This should successfully register the control.

 

Please help.  Thank you,

 

Answer
Answer

Don't waste your time and effort downloading other forms or files just search the file Mscomct2.ocx from Microsoft site and they will provide it to you as Cab file. To extract, you need 7.zip or any other file that can Extract the Cab file. after you extract follow this Solution that i got from this forum

https://social.technet.microsoft.com/Forums/windows/en-US/1fd6b78a-b1b3-4190-aceb-91575cd7092a/cannot-register-mscomct2ocx-using-regsvr32

Anyone who encounters error code 0*8002801c while trying to register mscomct2.ocx into system 32

Solution:
open command prompt as administrator and type this
C:\Windows\System32> regsvr32 wmnetmgr.dll
Press enter. Then type this
C:\Windows\System32> regsvr32 mscomct2.ocx
and press enter again. Succeeded!

YOU HAVE TO GO DEVELOPER, (CONTROL BAR)CHOOSE INSERT(NOT INSERT FROM THE MENU BAR) THE BOTTOM RIGHT CORNER CHOOSE MORE CONTROL, SCROLL TILL YOU SEE 
MICROSOFT DATE AND TIME PICKER CONTROL 6.0 (SP6)
WALAAAAA YOU GOT IT.

Problem solved!

I wanted to use this date picker in Excel 2010. I really HAD hard time  but now it works the way i wanted.

Needed Help

12 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated July 5, 2022 Views 147,422 Applies to: