***TROUBLE SHOOTING SUGGESTIONS*** Note: It seems as though this ocx file will only work with 32bit versions of Excel. It will work on both 32 & 64 bit machines but only 32 bit office apps. 1. Re-watch video and follow steps exactly. 2. Make sure you are opening the command prompt as administrator (right click>run as administrator) [ 2:15 ] 3. Verify the 'regsvr32 command and file path you are using are entered correctly. [ 2:22 ] 4. If you pasted the file path of the ocx file into the command prompt, make sure a "[?]" symbol did not appear in front of the path. If it did make sure to delete. [ 2:53 ] 5. Verify your command prompt active directory is set to "C:/Widows/System32" before running code (if not enter command 'cd C:/Widows/System32' and hit enter to change the working directory. Then run regsvr32 command. Note: Your file path may differ so verify this as well. 6. Try using 'regsvr32.exe' followed by the file path instead of just regsvr32. 7. Whether you are on a 64bit or 32bit machine, make sure to paste the files to the "SysWoW64" folder as I did. [ 1:40 ] 8. Try running the regsvr32 command with an active directory of "C:/Widows/SysWow64". Enter 'cd C:/Widows/SysWow64' to change the active directory. Then run the regsvr32 command with the location of your ocx file.
@DubaiRaja4 жыл бұрын
I did the same but still it is not showing in vba please suggest
@TheEngineeringToolboxChannel4 жыл бұрын
Are you using 32 or 64 bit Excel?
@DubaiRaja4 жыл бұрын
@@TheEngineeringToolboxChannel 64 bit
@TheEngineeringToolboxChannel4 жыл бұрын
Selvin Raja see the first sentence of the trouble shooting tips.
@stefanogattoCH2 жыл бұрын
Given most of the people use 64 bit version of Excel, maybe the best would be to notify in the title of this video that it's for Excel 32bits only. I spent precious minutes to find out, so writing it in the tile would help! Something like "Date Picker Control - Excel/32 bit ONLY! - VBA Data Entry Userform"
@mustafapatel33313 жыл бұрын
Finally!!! Thankfully this worked for me unlike other long videos with nothing🥳
@azorjistephen97073 ай бұрын
This was really Helpful. Thanks
@SwissMarkus Жыл бұрын
excellent tutorial exactly what I have been looking for .. thank you for your effort👍👌
@hatranthanh38133 жыл бұрын
Many thanks from VN
@jjoel35 жыл бұрын
Great job!!! Fixed an Issue been dealing with for two weeks!!!
@TheEngineeringToolboxChannel5 жыл бұрын
Joel Lengyel awesome! Glad I could help 👍
@joanmontana83594 жыл бұрын
Nprjoan thanks for the calendar control
@sonigajanand2 жыл бұрын
Great sir
@eggchipsnbeans3 жыл бұрын
Thank you, worked nicely
@kalite024 жыл бұрын
very useful.. many thanks
@FrancisAAfful3 жыл бұрын
for those having error with opening additional controls window, kindly change your excel combability to windows XP service pack 3.
@TheEngineeringToolboxChannel3 жыл бұрын
Awesome thanks!
@edwinosagiede23285 жыл бұрын
Great work. It worked for me.
@TheEngineeringToolboxChannel5 жыл бұрын
Awesome! Glad to hear it!
@piseyleang422 Жыл бұрын
I already registered successfully, but still i cannot see the DTPicker in my toolbox. Any advice?
@TheEngineeringToolboxChannel Жыл бұрын
You are likely running 64bit excel. This control only works on 32bit unfortunately.
@abbasnoufal92254 жыл бұрын
Ty so much for the easy Tutorial love it and u earn my sub
@TheEngineeringToolboxChannel4 жыл бұрын
Awesome glad you liked it!
@tylernichol64224 жыл бұрын
Very cool, thanks!
@suhasdeore32884 жыл бұрын
Thaks buddy its working
@tiroliroprou4 жыл бұрын
Hi, I did all the steps the video said, but when I try to add an additional control in my toolbox, the Microsoft date and time date picker control doesn't appears. Does anybody know why? PD. I already registered on cmd prompt the instruction thks
@TheEngineeringToolboxChannel4 жыл бұрын
Check pinned comment trouble shooting tips. Most common issue is that this does not work on 64 bit versions of excel
@aga51876 жыл бұрын
Thank you good man. Very greaat!!!
@aatishagarwal295 жыл бұрын
Thanks. It was so easy :)
@erkanbey7874 жыл бұрын
thanks for sharing but please put a note above as it doesn`t work with 64..Worked on that file several times with no luck...Then read the comments :)
@llobj0015 жыл бұрын
Can you do a video using VBA showing: 1) how to extract Global Address List GAL details from Outlook including user name into excel 2) how to cut and pasting details from Excell into Project (more efficient method than a loop etc) 3) how to use Excell data to write rules into outlook to auto sort emails (i.e. if you have a project number in excel, use that to write a rule that sorts emails if this number is found in the subject title and also ask if you want to assign a project number to an email before sending. 4) how to write a user form in word that will allow you to add new custom 'fields', insert them as you type and update them from the user form (accessible via its own ribbon icon). These features would be cool to see them working if you could build that functionality from an excel project spreadsheet. My challenge to you!
@TheEngineeringToolboxChannel5 жыл бұрын
This sounds like a challenge indeed...I would definitely need some time to look into this but I think it would be doable. I haven’t used VBA much for outlook or project.
@dipankarroy55292 жыл бұрын
Sir, I am using MS Office 2016 now.but the problem is that there is no Listview & Date picker option in the userform. I got Mscomtct2.ocx and Mscomctl from internet. I downloaded and installed the ocx file, after that there is Listview and Date picker file missing. how to solve ?
@TheEngineeringToolboxChannel2 жыл бұрын
Problem is likely that you are running a 64 bit version of excel. Unfortunately these controls are only available for 32bit versions.
@Sparqcorporatetraining4 жыл бұрын
Everything seems to work fine but when I go to activate it in the Toolbox, it's not there. I'm using 64 bit Excel. Is that the reason? You don't indicate that it only works in 32 bit Excel. What is the advantage / disadvantage of using 64 bit Excel and should I switch to 32 bit Office in order to do this? I hope not. Let me know? Thanks for your excellent instructions.
@disise57814 жыл бұрын
I have had the same issue
@danhiggins14274 жыл бұрын
Same here. Everything seemed to work except it is not appearing in the additional controls
@nizarelaouina17902 жыл бұрын
@@danhiggins1427 same here
@rubinator2000able3 жыл бұрын
followed all the steps and it seemed to be working but the last step is not, its not in the additional controlls, any clue?
@TheEngineeringToolboxChannel3 жыл бұрын
Did you check the pinned comment with trouble shooting tips?
@rubinator2000able3 жыл бұрын
@@TheEngineeringToolboxChannel yes
@TheEngineeringToolboxChannel3 жыл бұрын
@@rubinator2000able are you using 32 or 64 bit excel?
@rubinator2000able3 жыл бұрын
@@TheEngineeringToolboxChannel just fixed it, turned out i was doing these steps with a file called mscomctL.ocx istead of mscomct2.ocx. thanks for your help dude, works like a charm
@TheEngineeringToolboxChannel3 жыл бұрын
Awesome. Glad it worked out
@MrVigneshwaran443 жыл бұрын
Thank you
@TheEngineeringToolboxChannel3 жыл бұрын
No problem! Hope it was helpful. 👍
@vivekcardssambalpur31526 жыл бұрын
Thank you for helping
@TheEngineeringToolboxChannel6 жыл бұрын
Thank you for watching! 😀
@attilatoth15224 жыл бұрын
Thanks a lot, save me lots of time (Y)
@justcallmekrishmusic4 жыл бұрын
Will this work if the workbook is then used on a different pc which doesnt have the ocx file? Thanx
@TheEngineeringToolboxChannel4 жыл бұрын
Unfortunately it will not. The OCX file needs to be on every computer that uses the file.
@justcallmekrishmusic4 жыл бұрын
@@TheEngineeringToolboxChannel thank you
@wayneseymour16 жыл бұрын
I did exactly a you instructed it registered but still not showing up in the additional tools list I'm using Windows 10 64 bit Office 2016.
@TheEngineeringToolboxChannel6 жыл бұрын
Did you check the trouble shooting list that I pinned above? You may want to try move and register the file in the "system32" folder instead of the "SysWoW64" folder. Especially if you are running a 64bit version of Office. Depending on the version of Excel (32bit vs 64bit) may change where you need to register the file.
@wayneseymour16 жыл бұрын
did as you said even after placing it in the sys32 folder and successfully registering it it still does not show up in the additional tools list.
@gajanandhumal88835 жыл бұрын
@@wayneseymour1 same problem with me. Window 10
@TheEngineeringToolboxChannel5 жыл бұрын
@@gajanandhumal8883 It seems to be an issue with 64bit versions of Excel. I am seeing some threads out there that say this will not work on 64bit versions. social.technet.microsoft.com/Forums/en-US/e10f77f6-de14-41d9-971f-07e0ddf528e5/how-to-install-microsoft-date-and-time-picker-control-60-sp6-in-window-8?forum=excel The only thing I can suggest is to re-download Excel as a 32 bit version. Sorry about this! I did not realize it before making the video.
@milovanbusolich68975 жыл бұрын
@@gajanandhumal8883 Me too! What a bad shit
@dipankarroy55292 жыл бұрын
Sir, I want to use excel Calendar (no date time picker), but date format is becoming MM/DD/YYYY, I want format DD/MMM/YYYY, for example 21/Mar/2022 and also I want to use the same format in the Listbox1 . How can I do this by Userform in excel. Thank you.
@TheEngineeringToolboxChannel2 жыл бұрын
Try something along the lines of Format([date],”DD/MMM/YYYY”)
@mubasharhill71543 жыл бұрын
Hi. i have followed all steps successfully but still unable to see date and time picker into additional controls. Any additional suggestion for MS 2019? Thanks
@TheEngineeringToolboxChannel3 жыл бұрын
Did you check the pinned comment with trouble shooting tips?
@trantuananh19612 жыл бұрын
Thank for sharing! I have problem. I made complete excel macro file include Date & time picker inside userform. The file run well on my laptop (Windows x64 based, Office 32-bit). Anyway this file couldn't run on another PC (Windows x64 based, Office 64-bit). Some information I got show that: this Active X does not support to run on my case. Is this true? If not true, please advice me. Thanks in advance!
@TheEngineeringToolboxChannel2 жыл бұрын
This is true. This active x control does not run on excel 64 bit
@roronoazoro8343 Жыл бұрын
still the date picker wont show in the additional tool list
@wayneseymour16 жыл бұрын
OK I finally got it to load (reverted to office 32bit) and I have the Dtpicker icon on the tool pallet but when I go to use it I get a error "Class Factory Cannot Supply Requested Class". I uninstall it and reinstall it but get the same error. Tried both the System32 and sysWOW64 folders even the System folder with no lick. However I am able to use it on a spread sheet, just not on a user form. all other controls work fine just not the DTPicker or the Month-view controls. My office is up to date (Office2016 32bit on a Windows 10 64 bit machine. Is there a setting in the registry that needs to be changed? I have run out of options and have not found a solution on-line that works.
@TheEngineeringToolboxChannel6 жыл бұрын
That is very strange. I have never seen any error like that before. Just shooting in the dark here but try this... 1. Un-register both files using: "regsvr32 /u [File Path]" 2. Re-register just under the SysWoW64 since you are on a 32 bit version now 3. If that doesnt work.. 4. Un-register file again 5. Re-Download excel 32 bit version 6. re-register in SysWoW64
@bbierman74 жыл бұрын
Got it all set up! Curious, now how do I set it to look at my date column on a different tab in the same sheet?
@TheEngineeringToolboxChannel4 жыл бұрын
Hey Brendan, not quite sure what you mean. Feel free to email me and we can discuss more. I’d be happy to help. Theengineeringtoolbox@gmail.com
@edgeno2 жыл бұрын
Followed your steps but during registration im having this error message."The module "C:\Windows\SysWOW64\MSCOMCT2.OCX" was loaded but the call to DllRegisterServer failed error code 0x8002801c" please help
@TheEngineeringToolboxChannel2 жыл бұрын
Read the pinned comment for trouble shooting tips.
@spambiengentil2 жыл бұрын
@@TheEngineeringToolboxChannel We woud like but... where is it pinned ?? Thanks.
@marcelo6872 жыл бұрын
@@spambiengentil It's the first comment you can see below the video. Tell me if it worked for you
@spambiengentil2 жыл бұрын
@@marcelo687 Now i can see it. Strange, why the other day i can't ? Maybe i must wear goggles ^^ I have Office365 in 64bits so, no solution. Thank you ;-)
@AamirSaeedTajalli Жыл бұрын
hi, how can we set datepicker format DD-MMM-YYYY on run time? Kindly help.
@vasanthviswa72954 жыл бұрын
nice, also is there a way to to select year from list, month from list and finally date?
@TheEngineeringToolboxChannel4 жыл бұрын
Vasanth Viswa yes the year is built into the control on the top
@TheEngineeringToolboxChannel4 жыл бұрын
Vasanth Viswa sorry I think I misunderstood your question at first. Yes, you can have three combo boxes and then use those values in the dateserial() function to return the date. So yes it’s possible but I’m sure why you would want to do this instead of the date picker control.
@LamNguyen-WordUnveiled3 жыл бұрын
I did step by step. But MS Date and time not show in additional control.
@marcosmjjt4 жыл бұрын
How Can I use the "change" event each time I change the date? So, I want to do one thing every time the date is update, but I want do this without bottom. My question is if the datetimepicker has events like change or afterupdate
@TheEngineeringToolboxChannel4 жыл бұрын
Yes they do. Every editable control should have a change event.
@marcosmjjt4 жыл бұрын
The Engineering Toolbox Channel thank you for your reply. I used the change event from combobox but it didn’t work. I can’t find where is the change event of datetimepicker. So, I change the date on form and nothing happen. I must to create a pushbottom to get the date value, but I am trying a way to get the value after change date without any bottom.
@TheEngineeringToolboxChannel4 жыл бұрын
@@marcosmjjt open the userform in the VBA editor. Then double click data picker control. This will open the module for the userform. By default it will create a sub for the "callbackkeydown". In the top right of that window, there is a dropdown where you can select the change event. Once selected it will create a sub for the change event. This is where you can add your code. It should say something like "Private Sub DTPicker1_Change()". Be sure this matches the name of the date picker control.
@adnanalam37514 жыл бұрын
Thanks for the video. It's amazing but i just did't get the last part when you rename datepickers. There wasn't any textboxes , are the textboxes are hidden? or how did you have datepicker and textbox with the same name? and my datepickers do not get connected to textboxes. kindly consider it. Thanks alot
@TheEngineeringToolboxChannel4 жыл бұрын
Remember this was the third video in a series. If you go back and watch the previous videos it may make more sense.
@sajidakram78124 жыл бұрын
hi great videos where is the vba coding that allows you to put the date onto a cell in the worksheet
@TheEngineeringToolboxChannel4 жыл бұрын
Watch the previous videos in the series
@sajidakram78124 жыл бұрын
That’s what I tried to search for but cannot find in your uploads Please advise
@sajidakram78124 жыл бұрын
The Engineering Toolbox Channel I can’t find the video can you please send me the link
@TheEngineeringToolboxChannel4 жыл бұрын
kzbin.info/www/bejne/bXrEg2WmqJ19hJY start with this. Let me know if you have questions. Sorry for the bad quality it is an old video
@sajidakram78124 жыл бұрын
@@TheEngineeringToolboxChannel hi i have watched all 4 videos but in the video you do not go into how the date picker code shoild be written can you please send me the code allowing you to enter a date inside userform and transfering it onto a worksheet please.
@aadityarajshinde34694 жыл бұрын
Can you please suggest some alternative for MS Office 64-bit version?
@TheEngineeringToolboxChannel4 жыл бұрын
MS office 32bit is what you need to do this.
@johnjavier195 жыл бұрын
will it still work if i transfer the excel file to other pc?
@TheEngineeringToolboxChannel5 жыл бұрын
Good question! The OCX file will need to be downloaded and registered on all machines using the workbook. However, this control was included with versions prior to Excel 13 (i believe) so if they are on an older version they may not need to download and register the ocx file.
@BarbHendersonconsulting5 жыл бұрын
It seems to work fine when I install it on my user form, but when I click somewhere else on the form it disappears. All the other controls are working fine, I am confused
@TheEngineeringToolboxChannel5 жыл бұрын
Hmm. Hard to say what the issue is without seeing it. Feel free to email me screenshots of your issue at theengineeringtoolbox@gmail.com. Id be happy to help!
3 жыл бұрын
how to solve this "ClassFactory cannot supply requested Class" after I add this date picker
@bayanbiri33626 жыл бұрын
thanks , perfect
@asaadh1834 жыл бұрын
hey, i did everything u said, it got registered but the control still does not show up. can you help me?
@TheEngineeringToolboxChannel4 жыл бұрын
Did you read the pinned comment with trouble shooting suggestions?
@tulasharma24344 жыл бұрын
not work...i have try many time but no option showing
@TheEngineeringToolboxChannel4 жыл бұрын
Tula Sharma did you read the pinned comment with trouble shooting suggestions? Remember this will not work if you are on 64bit excel.
@naratsu054 жыл бұрын
do u have for list view?
@AweshBhornya-ExcelforNewbies4 жыл бұрын
This is the error i received while running this command in command prompt 'regsevr' is not recognized as an internal or external command, operable program or batch file.
@TheEngineeringToolboxChannel4 жыл бұрын
“Regsvr32” not regsevr
@AweshBhornya-ExcelforNewbies4 жыл бұрын
@@TheEngineeringToolboxChannel I checked it and managed to run it successfully and even after restarting the pc it is not showing up in additional controls
@mariuspetrucristea16864 жыл бұрын
is it possible to pickup ina cell data and in another one the time?
@TheEngineeringToolboxChannel4 жыл бұрын
Yes, this is possible. Please email me if you would like to discuss further. theengineeringtoolbox@gmail.com
@bharatgulyani1246 жыл бұрын
Great!!
@user-Agri-TEC3 жыл бұрын
what is that CMD command? is it "regswe32"
@TheEngineeringToolboxChannel3 жыл бұрын
regsvr32
@vinaynimje975 жыл бұрын
I m using date picker in userform but only two digit of date is saving in Sheet1
@TheEngineeringToolboxChannel5 жыл бұрын
vinay nimje hmm that’s strange it’s very hard to say what the issue is without see the workbook. Feel free to email me on this. Theengineeringtoolbox@gmail.com
@vinaynimje975 жыл бұрын
@@TheEngineeringToolboxChannel problem sloved.... I was using dtpicker.text instead I should used dtpicker1.value..... I have another question for you ... How can add search update value through userform to another workbook sheet in Excel or if I want to add update value in access
@TheEngineeringToolboxChannel5 жыл бұрын
vinay nimje thanks for the question. Again it is best if I can see what you are trying to in this case. Feel free contact me and discuss via email.
@contrasteseirl26715 жыл бұрын
Please, It works for Excel 2013, w7 64 bits?
@TheEngineeringToolboxChannel5 жыл бұрын
Thanks for the questions. See the pinned comment with trouble shooting suggestions. This will work with a 64bit computer but only if you have a 32bit version of excel downloaded.
@mahbub-e-ilahi59534 жыл бұрын
hi, how to add date picker tool in office 365, because date picker tool of office 2016 is not working in office 365
@TheEngineeringToolboxChannel4 жыл бұрын
Your issue is more than likely related to the bit version of 365 you are using. Check if you are using 64 bit excel.
@babyfaseena55045 жыл бұрын
does this require any specific coding in vba?
@TheEngineeringToolboxChannel5 жыл бұрын
Baby Faseena what you saw in this video is all that is required to use a date picker control.
@fabricioribeiro36825 жыл бұрын
Man, it isn't working on office 365. Please, could someone help me? I did rigister succefully the "MSCOMCT2.OCX" file, but even so it didn't work for me. The control do not show up on additional controls tab. What must I do?
@TheEngineeringToolboxChannel5 жыл бұрын
Did you read the pinned comment that says trouble shooting suggestions?
@Radik711013 жыл бұрын
Спасибо
@TheEngineeringToolboxChannel3 жыл бұрын
с удовольствием
@ferdinandogiordano21953 жыл бұрын
How can I set up a datepicker with the date of another datapicker from another sheet?
@TheEngineeringToolboxChannel3 жыл бұрын
Update the other one with the value of the first date picker during the change event.
@nrups98493 жыл бұрын
Can anyone tell me if I include the date picker in my workbook does it work if I send the file to another colleague who has not downloaded the file?
@TheEngineeringToolboxChannel3 жыл бұрын
This will not work l unless your colleague also has the date picker file installed.
@nrups98493 жыл бұрын
Just another Microsoft short coming. It just seems like we are loosing more and more functionality.
@TheEngineeringToolboxChannel3 жыл бұрын
@@nrups9849 agreed! It’s unfortunate
@sonasondarasaesaria1941 Жыл бұрын
Does anybody know what's the solution for office 64 bit?
@TheEngineeringToolboxChannel Жыл бұрын
There is not a way to get this exact control to work on 64bit excel. You can look into “Microsoft Monthview” control as another control option. kzbin.info/www/bejne/fHO3p5isr75rock
@sonasondarasaesaria1941 Жыл бұрын
@@TheEngineeringToolboxChannel OK I'll try it, thanks for the alternative option, really appreciate that!
@fabriziocarboni9765 жыл бұрын
Thanks, i lost two day to resolve this problem.
@TheEngineeringToolboxChannel5 жыл бұрын
Glad it helped!
@charlesessien36764 жыл бұрын
Thanks for the tutorial, i tried it but it didn't work. i use office 365
@TheEngineeringToolboxChannel4 жыл бұрын
See pinned comment titled “trouble shooting tips”
@Dhanashri0015 жыл бұрын
please show code for date picker.. im getting error method or data member not found
@TheEngineeringToolboxChannel5 жыл бұрын
If you want to see the code go back and watch previous videos and follow along. kzbin.info/www/bejne/bXrEg2WmqJ19hJY If you want me to help you trouble shoot your problem you will have to give me more information about when you get the error, what you are trying to do, etc. The data member not found usually means you are referring to an object or object member that does not exist or properly defined. If you would like to send me your file I can definitely help you...theengineeringtoolbox@gmail.com
@gustian_pandu72152 жыл бұрын
How to combine upload foto
@marcelo6872 жыл бұрын
It didn't work, I followed even the steps from the comment box, still not working. Good video tho
@TheEngineeringToolboxChannel2 жыл бұрын
Likely you are using 64 but excel then. Sorry!
@tricks4us3654 жыл бұрын
Can You Send Excel File...Please
@TheEngineeringToolboxChannel4 жыл бұрын
But I just showed you step by step how to do this...
@HariKrishna-my8bo4 жыл бұрын
@@TheEngineeringToolboxChannel i need vba code for that file..
@TheEngineeringToolboxChannel4 жыл бұрын
Hari Krishna yep all the vba code that is in the file is shown step by step in these videos. kzbin.info/aero/PLAVcy54svukfRIuXILzMGtvL1FCAsa6XZ
@mustafapatel33313 жыл бұрын
Everything went well accordingly until I entered the path location in command prompt, a message popped up saying, "This file does not have an app associated with it for performing this action......."
@TheEngineeringToolboxChannel3 жыл бұрын
Check file path again and make sure you spelled everything correctly in the cmd prompt
@mustafapatel33313 жыл бұрын
Awesome man, appreciate the support!
@mymrs52948 ай бұрын
Windows 7 download
@AbdulRehman-wn4wq6 жыл бұрын
it actually shown date picker button on my controls tab, but did not work
@TheEngineeringToolboxChannel6 жыл бұрын
Did you add this control or was it already there?
@AbdulRehman-wn4wq6 жыл бұрын
@@TheEngineeringToolboxChannel i add manually Mscomct 2 file, but didnot work
@TheEngineeringToolboxChannel6 жыл бұрын
Did you review the trouble shooting tips in the pinned comment of this video? What year of excel are you on? And what bit version (32 or 64)?
@AbdulRehman-wn4wq6 жыл бұрын
@@TheEngineeringToolboxChannel 64 bit 2016
@TheEngineeringToolboxChannel6 жыл бұрын
@@AbdulRehman-wn4wq Paste the OCX file in the system32 folder. run command prompt as administrator. make sure the working directory is set to "C:/Widows/System32" (or wherever that folder is located on your machine) and run "regsvr32 *File path to your ocx file*. Have you done as described above and checked the pinned trouble shooting tips above? If these suggestions do not work, consider reinstalling excel as a 32bit version. Then follow the steps in the video exactly. I know its not the best answer but it seems like people are having issues with 64 bit versions of excel.