UserForm ActiveX Date & Time Picker Missing? Here's how to get it back! 2018
|
#VBAA2Z
Please note that Date Picker is not available in 64-bit Excel.
Step by step on how to fix ActiveX Date and time picker and also for MonthView missing in Userform. These 2 controls uses same file that is ‘mscomct2.ocx’.
You can download the this file/’mscomct2.cab’ from below link
https://drive.google.com/folderview?id=0B8ypS-lfyrBVYVlzN2RYM3NlSlk&usp=sharing
Issue: Often when you try to register a DLL on Win7 or windows server 2008, you run into an error
«The module scmt.dll was loaded but the call to DllRegisterServer failed with the error code 0x80040201»
Why: UAC user account control limits the ability to register the DLL. so you have to run the command on elevated command prompt using Admin role.
Fix: Run the command in an elevated mode
1. Click on Start button – type Command Prompt – right click command prompt and click run as Administrator
2. Deregister the DLL using the following command
cmd- «regsvr32 /u scmt.dll»
3. Reregister the DLL using the command
cmd – «regsvr32 scmt.dll»
Also see instructions from this link
http://vbaa2z.wordpress.com/2014/12/30/install-date-picker-for-ms-excel/
related errors;
The module xxx.dll was loaded but the call to DllRegisterServer failed with error code 0x8002801c” while registering dll files
DLLRegisterserver failed with error code 0x8002801 the change the security settings if you do not have admin right on your system use this link for further research
All relevant materials used for this episode can be downloaded from the link below. Please support us by liking our videos and subscribing to our channel so that we can make more free videos like this.
If you have any questions/feedback/tutorial request, please feel to comment below or directly email us at [email protected] and I will try and come back as soon as possible.
Link: http://vbaa2z.blogspot.com/
http://answers.microsoft.com/en-us/windows/forum/windows_7-performance/the-module-xxxdll-was-loaded-but-the-call-to/25b1a64c-7c10-4af2-896f-932195f40045
HOLA TE OFRECEMOS ESTE VIDEO PARA VERLO DE FORMA ONLINE ? Y DISPONIBLE PARA LA DESCARGA ?
CANTIDAD DE VISITAS QUE TUVO EL VIDEO : 44878 PERSONAS LO VIERON
RATING : 4.43 ⋆⋆⋆⋆⋆
DURACION DEL VIDEO 4:10 ?
FECHA EN LA QUE SE SUBIO EL VIDEO 2014-12-30 20:21:17 ?
CUANTOS ME GUSTA OBTUVO 125 ?
Te informamos que los estrenos más esperados. Las mejores Películas de la historia, tus series favoritas ANIME, ya puedes mirarlas aquí!
Un programa informático escrito en un estilo orientado a objetos.
Un programa informático o programa de computadora es una secuencia de instrucciones, escritas para realizar una tarea específica en una computadora.1 Este dispositivo requiere programas para funcionar, por lo general, ejecutando las instrucciones del programa en un procesador central.2 El programa tiene un formato ejecutable que la computadora puede utilizar directamente para ejecutar las instrucciones. El mismo programa en su formato de código fuente legible para humanos, del cual se derivan los programas ejecutables (por ejemplo, compilados), le permite a un programador estudiar y desarrollar sus algoritmos. Una colección de programas de computadora y datos relacionados se conoce como software.
Muchos programas diseñados para Windows pueden llegar a costar hasta cientos de euros. Si vas a utilizar alguno de estos programas de continuo, puede que sí que te interese pagar el precio del software.
Sin embargo, si solo necesitas usar el programa alguna que otra vez puede que su precio no te compense. Es por ello que queremos proponerte una lista de alternativas gratuitas a esos programas de pago para Windows.
A continuación te mostramos los mejores software gratis para Windows que puedes descargar fácilmente sin gastar ni un solo euro.
Good
This was very helpful. Thank you very very much.
I've tried this at 2 laptop, both time it was successful form with date picker working nicely, but then when I've tried same thing with following same step one by one another 2 laptop but, every occasions it's showing succeeded but when I'm running form with date picker object, there is error msg showing on screen by mentioning that, object not found… So please help me out to sort out this problem.. I'm waiting for your positive response..
thanks for your video ..in 0:55 how do i change the path of this folder to the folder sysWOW64 , I already put the mscomct2.ocx inside SysWOW64…(and registered) but the dialog box show to me only this path c:windowssystem32wiaaut.dll currently I using excell 2013 version. thanks please help
Thank you for your help
Hi Please help, not working in my window 8.1 and 32 bit, Excel version is 2010.
Awesome!!! thanx, I thought its not possible 😛
Champion! fixed my issue
Worked 😀
Thanks!
THANK YOU!!!!!!!!
64bit – 2013 excel
worked…thank you
CANT FIND IT!!
Please explain why something so rudimentary when using spreadsheets as a date picker is so complicated to add! I do not have the feature in my Excel version. I have tried every trick I can find on the internet to add it in. Why is it not just a standard feature? I will find a more user friendly software.
Thanks man!! I was having a lot of troubles to solve this problem.
THANKS MAN!! YOU ARE A GENIOUS…I had a problem with this f*cker since I formatted my system. The dll wouldn't load!!!
thank you dear
Still didn't work on excel 2016
thanks dear
thanks
thank you! worked perfect!
Thank you for your help. Worked a treat!
I get the error message "access denied: You don't have permission to access "http://activex.microsoft.com/controls/vb6/mscomct2.cab" on this server"
thanks , god bless you and your family
thank u very much ! i spent 2 hours tryng to find a solution before finding ur video
Thank you!
Thanks a lot for the fix.. it really helped me since i had this Ticket for like a week… didn't knew how to fix it. User was happy Thanks
I successfully added mscomct2.ocx file as you at 3:21, but after i open toolbox i cannot find it there. I did not find it in right click> additional controls either. Any suggestions ? Thank you.
could not paste."access denied"… what to do ?
This was a bit fast when demonstrating the technical parts. I was not able to register it. I got the error even though I was at the windows command prompt and not the sys32.Please help, thanks.
Do you think you could do this again but much slower. Not a computer wizz and need it spelt out, one step at a time. Thanks.!
História divulga meu canal